Oracle Debrief Charges Process

Charges process: After the CSR debriefs a task, once the task status is changed to 'Completed'/Suspended'/Cancelled/Rejected, a concurrent program "Debrief Posting Program" is called. This program creates the charges lines as per the task debrief (The charges are associated with the SR).

The program calls Package CSF_DEBRIEF_UPDATE_PKG which calls CSF_DEBRIEF_CHARGES which calls CS_Service_Billing_Engine_PVT which calls CS_Charge_Details_PUB which calls CS_Charge_Details_PVT which calls CS_ESTIMATE_DETAILS_PKG.

The package CS_ESTIMATE_DETAILS_PKG inserts a record into table CS_ESTIMATE_DETAILS for each debrief line. Prior to calling CS_ESTIMATE_DETAILS_PKG, the package CS_Charge_Details_PVT invokes a pre hook and after insertion it calls post hook API.

The hook needs to be registered. I did this by running this query

insert into JTF_USER_HOOKS values (9999999, 'CS_CHARGE_DETAILS_PVT', 'Create_Charge_Details', 'CS', 'A', 'Y', 'C',

1159, sysdate, 1159, sysdate, 0, null, null, null, null, null)

Field description:

The first 3 parameters need to be these 3 values specified for debrief. A signifies post hook (B is for prehook), Y is set to enable the hook (N is to disable), 7th parameter should be 'C' (Customer Hook) rest all fields are WHO fields/attributes (attributes are blank).

The hook package that is called by CS_Charge_Details_PVT is CS_CHARGE_DETAILS_CUHK. It contains methods Create_Charge_Details_Pre, Create_Charge_Details_Post, Update_Charge_Details_Pre, Update_Charge_Details_Post. Oracle has provided the package specification for this hook. We would need to create the package body.