DBA Data[Home] [Help]

APPS.INV_3PL_SEEDED_SOURCES dependencies on FND_PROFILE

Line 5: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1: PACKAGE BODY INV_3PL_SEEDED_SOURCES AS
2: /* $Header: INVSSRCB.pls 120.1 2010/05/26 09:11:20 damahaja noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_3PL_SEEDED_SOURCES';
5: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6:
7:
8: PROCEDURE debug(
9: p_message IN VARCHAR2

Line 612: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');

608:
609: END IF; /* (locator_occupancy_rec.current_onhand = 0 ) */
610:
611:
612: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
613: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
614: l_applid := FND_PROFILE.value('PROG_APPL_ID');
615:
616: BEGIN

Line 613: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');

609: END IF; /* (locator_occupancy_rec.current_onhand = 0 ) */
610:
611:
612: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
613: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
614: l_applid := FND_PROFILE.value('PROG_APPL_ID');
615:
616: BEGIN
617: SELECT 'Y'

Line 614: l_applid := FND_PROFILE.value('PROG_APPL_ID');

610:
611:
612: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
613: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
614: l_applid := FND_PROFILE.value('PROG_APPL_ID');
615:
616: BEGIN
617: SELECT 'Y'
618: INTO l_lock_record

Line 804: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');

800: END IF;
801: /* (locator_occupancy_rec.current_onhand = 0 ) */
802:
803:
804: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
805: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
806: l_applid := FND_PROFILE.value('PROG_APPL_ID');
807:
808: BEGIN

Line 805: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');

801: /* (locator_occupancy_rec.current_onhand = 0 ) */
802:
803:
804: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
805: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
806: l_applid := FND_PROFILE.value('PROG_APPL_ID');
807:
808: BEGIN
809: SELECT 'Y'

Line 806: l_applid := FND_PROFILE.value('PROG_APPL_ID');

802:
803:
804: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
805: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
806: l_applid := FND_PROFILE.value('PROG_APPL_ID');
807:
808: BEGIN
809: SELECT 'Y'
810: INTO l_lock_record

Line 982: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');

978: END IF;
979:
980: /* (locator_occupancy_rec.current_onhand = 0 ) */
981:
982: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
983: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
984: l_applid := FND_PROFILE.value('PROG_APPL_ID');
985:
986: BEGIN

Line 983: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');

979:
980: /* (locator_occupancy_rec.current_onhand = 0 ) */
981:
982: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
983: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
984: l_applid := FND_PROFILE.value('PROG_APPL_ID');
985:
986: BEGIN
987: SELECT 'Y'

Line 984: l_applid := FND_PROFILE.value('PROG_APPL_ID');

980: /* (locator_occupancy_rec.current_onhand = 0 ) */
981:
982: l_progid := FND_PROFILE.value('CONC_PROGRAM_ID');
983: l_reqstid := FND_PROFILE.value('CONC_REQUEST_ID');
984: l_applid := FND_PROFILE.value('PROG_APPL_ID');
985:
986: BEGIN
987: SELECT 'Y'
988: INTO l_lock_record