APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on CSL_MTL_SYSTEM_ITEMS_ACC_PKG

Line 1: PACKAGE BODY CSL_MTL_SYSTEM_ITEMS_ACC_PKG AS

1: PACKAGE BODY CSL_MTL_SYSTEM_ITEMS_ACC_PKG AS
2: /* $Header: cslsiacb.pls 120.1 2011/06/16 07:35:37 saradhak ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_SYSTEM_ITEMS_ACC';

Line 1627: where package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'

1623: CURSOR c_LastRundate
1624: IS
1625: select LAST_RUN_DATE
1626: from JTM_CON_REQUEST_DATA
1627: where package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'
1628: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1629: r_LastRundate c_LastRundate%ROWTYPE;
1630:
1631: /*** cursor retrieving list of resources subscribed to publication item ***/

Line 1728: WHERE package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'

1724:
1725: /*Update the last run date*/
1726: UPDATE JTM_CON_REQUEST_DATA
1727: SET LAST_RUN_DATE = l_current_run_date
1728: WHERE package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'
1729: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1730:
1731: COMMIT;
1732:

Line 1755: END CSL_MTL_SYSTEM_ITEMS_ACC_PKG;

1751: END IF;
1752: ROLLBACK;
1753: END CON_REQUEST_MTL_SYSTEM_ITEMS;
1754:
1755: END CSL_MTL_SYSTEM_ITEMS_ACC_PKG;