APPS.INV_REDUCE_MOQD_PVT dependencies on FND_PROFILE

Line 23: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

19: RETCODE OUT NOCOPY NUMBER ,
20: P_ORG_ID IN NUMBER
21: ) IS
22:
23: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: l_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_FIFO_ORIG_REC_DATE'),'N');
25: l_user_id NUMBER := NVL(FND_PROFILE.VALUE('USER_ID'),-999);
26: l_request_id NUMBER := NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'),-999);
27:

Line 24: l_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_FIFO_ORIG_REC_DATE'),'N');

20: P_ORG_ID IN NUMBER
21: ) IS
22:
23: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: l_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_FIFO_ORIG_REC_DATE'),'N');
25: l_user_id NUMBER := NVL(FND_PROFILE.VALUE('USER_ID'),-999);
26: l_request_id NUMBER := NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'),-999);
27:
28: l_moq_count NUMBER;

Line 25: l_user_id NUMBER := NVL(FND_PROFILE.VALUE('USER_ID'),-999);

21: ) IS
22:
23: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: l_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_FIFO_ORIG_REC_DATE'),'N');
25: l_user_id NUMBER := NVL(FND_PROFILE.VALUE('USER_ID'),-999);
26: l_request_id NUMBER := NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'),-999);
27:
28: l_moq_count NUMBER;
29: l_moq_sum NUMBER;

Line 26: l_request_id NUMBER := NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'),-999);

22:
23: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
24: l_profile VARCHAR2(1) := NVL(FND_PROFILE.VALUE('INV_FIFO_ORIG_REC_DATE'),'N');
25: l_user_id NUMBER := NVL(FND_PROFILE.VALUE('USER_ID'),-999);
26: l_request_id NUMBER := NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'),-999);
27:
28: l_moq_count NUMBER;
29: l_moq_sum NUMBER;
30: l_moq_backup_count NUMBER;

Line 79: -- If fnd_profile returns 'N' for the profile, then make sure that this profile is not

75: END IF;
76:
77: l_stmt_count := 100;
78:
79: -- If fnd_profile returns 'N' for the profile, then make sure that this profile is not
80: -- set to 'Y' at any other levels before proceeding with onhand consolidation.
81:
82: IF (l_profile = 'N') THEN
83:

Line 87: FROM fnd_profile_options o, fnd_profile_option_values v

83:
84: l_stmt_count := 110;
85:
86: SELECT count(1) INTO l_prof_cnt
87: FROM fnd_profile_options o, fnd_profile_option_values v
88: WHERE o.profile_option_name = 'INV_FIFO_ORIG_REC_DATE'
89: AND o.start_date_active <= sysdate
90: AND (nvl(o.end_date_active,sysdate) >= sysdate)
91: AND o.profile_option_id = v.profile_option_id