APPS.MSC_SRP_RELEASE dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 1077: SELECT wip_job_schedule_interface_s.NEXTVAL

1073: -- COMMIT;
1074: BEGIN -- CAll to API TO Create a WIP JOb
1075: LOG_MESSAGE('-------------------------------------------------------------------');
1076: l_user_id := fnd_global.user_id();
1077: SELECT wip_job_schedule_interface_s.NEXTVAL
1078: INTO l_group_id FROM dual;
1079:
1080: Select To_Char(WIP_JOB_NUMBER_S.NEXTVAL)
1081: into l_wip_job_name from dual;

Line 1085: LOG_MESSAGE('Inserting into wip_job_schedule_interface');

1081: into l_wip_job_name from dual;
1082: --l_group_id
1083: BEGIN
1084: -- INSERTING WIP JOB
1085: LOG_MESSAGE('Inserting into wip_job_schedule_interface');
1086:
1087: INSERT INTO wip_job_schedule_interface
1088: (
1089: last_update_date,

Line 1087: INSERT INTO wip_job_schedule_interface

1083: BEGIN
1084: -- INSERTING WIP JOB
1085: LOG_MESSAGE('Inserting into wip_job_schedule_interface');
1086:
1087: INSERT INTO wip_job_schedule_interface
1088: (
1089: last_update_date,
1090: last_updated_by,
1091: creation_date,

Line 1134: LOG_MESSAGE('Inserted into wip_job_schedule_interface group id '||to_char(l_group_id));

1130: l_ro_release.Inventory_item_id,
1131: l_group_id
1132: );
1133:
1134: LOG_MESSAGE('Inserted into wip_job_schedule_interface group id '||to_char(l_group_id));
1135:
1136: LOG_MESSAGE('Calling API WIP_MASSLOAD_PUB.createOneJob');
1137:
1138: WIP_MASSLOAD_PUB.createOneJob( p_interfaceID => l_group_id,