APPS.MRP_AP_REL_PLAN_PUB dependencies on FND_PROFILE

Line 36: var_purchasing_by_rev NUMBER := to_number(FND_PROFILE.VALUE('MRP_PURCHASING_BY_REVISION'));

32: G_OPR_UPDATE CONSTANT INTEGER := 2; -- dsr
33:
34: NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
35:
36: var_purchasing_by_rev NUMBER := to_number(FND_PROFILE.VALUE('MRP_PURCHASING_BY_REVISION'));
37:
38: var_lot_job_copy_rout NUMBER := to_number(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'));
39:
40: v_instance_id NUMBER;

Line 38: var_lot_job_copy_rout NUMBER := to_number(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'));

34: NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
35:
36: var_purchasing_by_rev NUMBER := to_number(FND_PROFILE.VALUE('MRP_PURCHASING_BY_REVISION'));
37:
38: var_lot_job_copy_rout NUMBER := to_number(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'));
39:
40: v_instance_id NUMBER;
41: v_dblink VARCHAR2(128);
42: v_instance_code VARCHAR2(3);

Line 119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),

115: BEGIN
116:
117: SELECT wip_job_schedule_interface_s.nextval,
118: mrp_workbench_query_s.nextval,
119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),
121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),
122: NVL(FND_PROFILE.VALUE('MSC_UPD_REQ_DATE_REL'),'N')
123: INTO G_WIP_GROUP_ID,

Line 120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),

116:
117: SELECT wip_job_schedule_interface_s.nextval,
118: mrp_workbench_query_s.nextval,
119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),
121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),
122: NVL(FND_PROFILE.VALUE('MSC_UPD_REQ_DATE_REL'),'N')
123: INTO G_WIP_GROUP_ID,
124: G_PO_BATCH_NUMBER,

Line 121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),

117: SELECT wip_job_schedule_interface_s.nextval,
118: mrp_workbench_query_s.nextval,
119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),
121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),
122: NVL(FND_PROFILE.VALUE('MSC_UPD_REQ_DATE_REL'),'N')
123: INTO G_WIP_GROUP_ID,
124: G_PO_BATCH_NUMBER,
125: -- PV_RESOURCE_TYPE,

Line 122: NVL(FND_PROFILE.VALUE('MSC_UPD_REQ_DATE_REL'),'N')

118: mrp_workbench_query_s.nextval,
119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),
121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),
122: NVL(FND_PROFILE.VALUE('MSC_UPD_REQ_DATE_REL'),'N')
123: INTO G_WIP_GROUP_ID,
124: G_PO_BATCH_NUMBER,
125: -- PV_RESOURCE_TYPE,
126: PV_RES_PRIORITY,