APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on CSL_MTL_SEC_LOCATORS_ACC_PKG

Line 1: PACKAGE BODY CSL_MTL_SEC_LOCATORS_ACC_PKG AS

1: PACKAGE BODY CSL_MTL_SEC_LOCATORS_ACC_PKG AS
2: /* $Header: cslslacb.pls 120.1 2005/06/01 23:39:40 appldev $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_MTL_SECONDARY_LOCATORS_ACC';

Line 460: where package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'

456: CURSOR c_LastRundate
457: IS
458: select LAST_RUN_DATE
459: from JTM_CON_REQUEST_DATA
460: where package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'
461: AND procedure_name = 'CON_REQUEST_SECONDARY_LOCATORS';
462: r_LastRundate c_LastRundate%ROWTYPE;
463: l_current_run_date DATE;
464: BEGIN

Line 511: WHERE package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'

507:
508: /*Update the last run date*/
509: UPDATE JTM_CON_REQUEST_DATA
510: SET LAST_RUN_DATE = l_current_run_date
511: WHERE package_name = 'CSL_MTL_SEC_LOCATORS_ACC_PKG'
512: AND procedure_name = 'CON_REQUEST_SECONDARY_LOCATORS';
513:
514: COMMIT;
515:

Line 538: END CSL_MTL_SEC_LOCATORS_ACC_PKG; -- Package Body CSL_MTL_SEC_LOCATORS_ACC_PKG

534: END IF;
535: ROLLBACK;
536: END CON_REQUEST_SECONDARY_LOCATORS;
537:
538: END CSL_MTL_SEC_LOCATORS_ACC_PKG; -- Package Body CSL_MTL_SEC_LOCATORS_ACC_PKG