APPS.CSL_JTF_TASK_REFS_ACC_PKG dependencies on CSL_JTF_TASK_REFS_ACC_PKG

Line 1: PACKAGE BODY CSL_JTF_TASK_REFS_ACC_PKG AS

1: PACKAGE BODY CSL_JTF_TASK_REFS_ACC_PKG AS
2: /* $Header: cslteacb.pls 115.6 2002/11/08 14:01:15 asiegers ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_TASK_REFERENCES_ACC';

Line 51: where package_name = 'CSL_JTF_TASK_REFS_ACC_PKG'

47: CURSOR c_LastRundate
48: IS
49: select LAST_RUN_DATE
50: from JTM_CON_REQUEST_DATA
51: where package_name = 'CSL_JTF_TASK_REFS_ACC_PKG'
52: AND procedure_name = 'CON_REQUEST_TASK_REFERENCES';
53: r_LastRundate c_LastRundate%ROWTYPE;
54: l_last_rundate DATE;
55: l_return_status VARCHAR2(2000);

Line 101: WHERE package_name = 'CSL_JTF_TASK_REFS_ACC_PKG'

97:
98: /*Update the last run date*/
99: UPDATE JTM_CON_REQUEST_DATA
100: SET LAST_RUN_DATE = SYSDATE
101: WHERE package_name = 'CSL_JTF_TASK_REFS_ACC_PKG'
102: AND procedure_name = 'CON_REQUEST_TASK_REFERENCES';
103:
104: FOR r_task IN c_task LOOP
105: /*Get all escaleted tasks not yet in the acc table*/

Line 233: END CSL_JTF_TASK_REFS_ACC_PKG;

229: ROLLBACK;
230: RAISE;
231: END DELETE_ALL_ACC_RECORDS;
232:
233: END CSL_JTF_TASK_REFS_ACC_PKG;