APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on CSL_MTL_SERIAL_NUMBERS_ACC_PKG

Line 1: PACKAGE BODY CSL_MTL_SERIAL_NUMBERS_ACC_PKG AS

1: PACKAGE BODY CSL_MTL_SERIAL_NUMBERS_ACC_PKG AS
2: /* $Header: cslsnacb.pls 115.6 2004/09/30 22:10:00 appldev ship $ */
3:
4: /*** Globals ***/
5: g_debug_level NUMBER; -- debug level

Line 336: where package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'

332: CURSOR c_LastRundate
333: IS
334: select LAST_RUN_DATE
335: from JTM_CON_REQUEST_DATA
336: where package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'
337: AND procedure_name = 'CON_REQUEST_SERIAL_NUMBERS';
338:
339: BEGIN
340: /*** get debug level ***/

Line 368: WHERE package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'

364:
365: /*Update the last run date*/
366: UPDATE JTM_CON_REQUEST_DATA
367: SET LAST_RUN_DATE = SYSDATE
368: WHERE package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'
369: AND procedure_name = 'CON_REQUEST_SERIAL_NUMBERS';
370:
371: COMMIT;
372: /*First remove all records no longer required*/

Line 407: END CSL_MTL_SERIAL_NUMBERS_ACC_PKG;

403: ROLLBACK;
404: RETURN;
405: END CON_REQUEST_SERIAL_NUMBERS;
406:
407: END CSL_MTL_SERIAL_NUMBERS_ACC_PKG;