DBA Data[Home] [Help]

APPS.CSD_RECALLS_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 1095: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

1091: l_job_header_tbl(l_job_header_index).class_code := p_wip_accounting_class;
1092:
1093: IF l_group_id = 0
1094: THEN
1095: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1096: END IF;
1097: l_job_header_tbl(l_job_header_index).group_id := l_group_id;
1098: l_job_header_index := l_job_header_index + 1; -- bug#9754933
1099:

Line 1131: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

1127: l_job_header_tbl(l_job_header_index).class_code := p_wip_accounting_class;
1128:
1129: IF l_group_id = 0
1130: THEN
1131: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1132: END IF;
1133: l_job_header_tbl(l_job_header_index).group_id := l_group_id;
1134: l_job_header_index := l_job_header_index + 1;
1135: END LOOP;

Line 1153: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.

1149: write_to_conc_out(p_group_id);
1150: COMMIT WORK;
1151: RETURN;
1152: END IF;
1153: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.
1154: FORALL j IN 1 ..l_job_header_tbl.COUNT
1155: INSERT INTO wip_job_schedule_interface VALUES l_job_header_tbl(j);
1156:
1157: COMMIT WORK;

Line 1155: INSERT INTO wip_job_schedule_interface VALUES l_job_header_tbl(j);

1151: RETURN;
1152: END IF;
1153: -- insert the job header rec into wip_job_schedule_interface_table and call the CP.
1154: FORALL j IN 1 ..l_job_header_tbl.COUNT
1155: INSERT INTO wip_job_schedule_interface VALUES l_job_header_tbl(j);
1156:
1157: COMMIT WORK;
1158: -- submit wip mass load as child request for the entire group.
1159: x_request_id := fnd_request.submit_request (