APPS.CSD_RECALLS_PVT dependencies on DUAL

Line 530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;

526: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
527: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Update the recall lines as processing');
528: END IF;
529:
530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;
531:
532: -- update the selected recall line id's as processing flag = 'Y';
533: UPDATE CSD_RECALL_LINES crl SET processing_flag = 'Y', processing_group_id = l_group_id
534: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))

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;