113: l_resp_id NUMBER;
114: lv_log_msg varchar2(500);
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')),
127: PV_SIM_RES_SEQ,
128: PV_REL_REQUEST_DATE
129: FROM DUAL;
130:
131: SELECT wip_job_schedule_interface_s.nextval
132: INTO G_OPM_WIP_GROUP_ID
133: FROM DUAL;
134:
135: p_wip_group_id := G_WIP_GROUP_ID;