DBA Data[Home] [Help]

APPS.MRP_LAUNCH_PLAN_PK dependencies on FND_PROFILE

Line 31: G_MRP_DEBUG := FND_PROFILE.VALUE('MRP_DEBUG') ; /*2663505*/

27:
28: G_MRP_DEBUG VARCHAR2(1); /*2663505*/
29:
30: BEGIN
31: G_MRP_DEBUG := FND_PROFILE.VALUE('MRP_DEBUG') ; /*2663505*/
32:
33: /*----------------------------------------+
34: | Update mrp_plans with plan horizon date |
35: +----------------------------------------*/

Line 43: months := fnd_profile.value('MRP_CUTOFF_DATE_OFFSET');

39: MRP_UTIL.Mrp_Debug('******About to Launch Plan******');
40: END IF ; /*2663505*/
41:
42: IF arg_plan_horizon IS NULL THEN
43: months := fnd_profile.value('MRP_CUTOFF_DATE_OFFSET');
44:
45: var_new_date := MRP_CALENDAR.NEXT_WORK_DAY(arg_org_id,1,
46: TO_DATE(TO_CHAR(add_months(sysdate, NVL(months, 12)),
47: 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')) ;

Line 82: var_user_id := fnd_profile.value('USER_ID');

78: /*-------------+
79: | Get user id |
80: +--------------*/
81:
82: var_user_id := fnd_profile.value('USER_ID');
83: /*-----------------------------------------------+
84: | Insert subinventories into mrp_sub_inventories |
85: | that are defined after options are defined |
86: +-----------------------------------------------*/