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.0 2005/05/24 18:40:25 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_SYSTEM_ITEMS_ACC';

Line 1811: where package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'

1807: CURSOR c_LastRundate
1808: IS
1809: select LAST_RUN_DATE
1810: from JTM_CON_REQUEST_DATA
1811: where package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'
1812: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1813: r_LastRundate c_LastRundate%ROWTYPE;
1814:
1815: /*** cursor retrieving list of resources subscribed to publication item ***/

Line 1912: WHERE package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'

1908:
1909: /*Update the last run date*/
1910: UPDATE JTM_CON_REQUEST_DATA
1911: SET LAST_RUN_DATE = l_current_run_date
1912: WHERE package_name = 'CSL_MTL_SYSTEM_ITEMS_ACC_PKG'
1913: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1914:
1915: COMMIT;
1916:

Line 1939: END CSL_MTL_SYSTEM_ITEMS_ACC_PKG;

1935: END IF;
1936: ROLLBACK;
1937: END CON_REQUEST_MTL_SYSTEM_ITEMS;
1938:
1939: END CSL_MTL_SYSTEM_ITEMS_ACC_PKG;