APPS.CSP_REPAIR_PO_GRP dependencies on DUAL

Line 117: SELECT Sysdate INTO l_today FROM dual;

113:
114: l_defective_parts_tbl := p_defective_parts_tbl;
115:
116: /* -------- User and Login Information -------- */
117: SELECT Sysdate INTO l_today FROM dual;
118: l_user_id := fnd_global.user_id;
119: l_login_id := fnd_global.login_id;
120:
121: /* --------- Start Create Reservations for Defective Parts passed ----------- */

Line 132: Select MTL_DEMAND_S.NEXTVAL INTO l_demand_source_line_id FROM DUAL;

128: l_reservation_rec.item_id := l_defective_parts_rec.defective_item_id;
129: l_reservation_rec.quantity_needed := l_defective_parts_rec.defective_quantity;
130: l_reservation_rec.sub_inventory_code := Null;
131: -- SELECT nvl(MAX(RESERVATION_ID),0) + 1 into l_demand_source_line_id FROM MTL_RESERVATIONS;
132: Select MTL_DEMAND_S.NEXTVAL INTO l_demand_source_line_id FROM DUAL;
133: l_reservation_rec.line_id := l_demand_source_line_id;
134:
135: If l_defective_parts_rec.defective_quantity <= 0 then
136: FND_MESSAGE.SET_NAME ('CSP','CSP_INVALID_DEFECTIVE_QUANTITY');

Line 329: from dual;

325: End;
326:
327: select csp_repair_po_headers_s1.nextval
328: into l_repair_po_header_id
329: from dual;
330:
331: /* In "CSP_PARTS_ORDER.PROCESS_PURCHASE_REQ" API inserting into
332: "PO_REQUISITIONS_INTERFACE_ALL" table SOURCE_TYPE_CODE as "VENDOR".
333: So this item must be Purchasing_enabled in both Repair supplier org and destination org. */

Line 503: from dual;

499:
500: /*
501: select po_notes_s.nextval
502: into p_note_id
503: from dual;
504:
505: Insert into PO_NOTES
506: (
507: PO_NOTE_ID

Line 704: from dual;

700: l_out_reservation_rec := l_out_reservation_tbl(I);
701:
702: select csp_repair_po_lines_s1.nextval
703: into l_repair_po_line_id
704: from dual;
705:
706: INSERT INTO CSP_REPAIR_PO_LINES
707: (
708: REPAIR_PO_LINE_ID