APPS.MSC_SRP_RELEASE dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 1080: SELECT wip_job_schedule_interface_s.NEXTVAL

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

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

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

Line 1090: INSERT INTO wip_job_schedule_interface

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

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

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