APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on CSL_MTL_ITEM_LOCATIONS_ACC_PKG

Line 1: PACKAGE BODY CSL_MTL_ITEM_LOCATIONS_ACC_PKG AS

1: PACKAGE BODY CSL_MTL_ITEM_LOCATIONS_ACC_PKG AS
2: /* $Header: cslmlacb.pls 115.1 2003/10/24 23:35:06 yliao noship $ */
3:
4: /*
5: This package will be called from CSL_CSP_INV_LOC_ASS_ACC_PKG.

Line 516: where package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'

512: CURSOR c_LastRundate
513: IS
514: select LAST_RUN_DATE
515: from JTM_CON_REQUEST_DATA
516: where package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'
517: AND procedure_name = 'CON_REQUEST_MTL_ITEM_LOCATIONS';
518: r_LastRundate c_LastRundate%ROWTYPE;
519: l_current_run_date DATE;
520: BEGIN

Line 567: WHERE package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'

563:
564: /*Update the last run date*/
565: UPDATE JTM_CON_REQUEST_DATA
566: SET LAST_RUN_DATE = l_current_run_date
567: WHERE package_name = 'CSL_MTL_ITEM_LOCATIONS_ACC_PKG'
568: AND procedure_name = 'CON_REQUEST_ITEM_LOCATIONS';
569:
570: COMMIT;
571:

Line 594: END CSL_MTL_ITEM_LOCATIONS_ACC_PKG;

590: END IF;
591: ROLLBACK;
592: END CON_REQUEST_ITEM_LOCATIONS;
593:
594: END CSL_MTL_ITEM_LOCATIONS_ACC_PKG;