APPS.CSP_PARTS_ORDER dependencies on PO_REQUISITION_HEADERS

Line 1172: SELECT rowid FROM PO_REQUISITION_HEADERS

1168: l_oe_Request_Tbl_Type oe_order_pub.Request_tbl_type := OE_ORDER_PUB.G_MISS_REQUEST_TBL;
1169: l_oe_control_rec OE_GLOBALS.Control_Rec_Type;
1170:
1171: CURSOR rowid_cur IS
1172: SELECT rowid FROM PO_REQUISITION_HEADERS
1173: WHERE requisition_header_id = l_header_rec.requisition_header_id;
1174:
1175: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1176: CURSOR req_number_cur IS

Line 1179: WHERE table_name = 'PO_REQUISITION_HEADERS'

1175: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1176: CURSOR req_number_cur IS
1177: SELECT to_char(current_max_unique_identifier + 1)
1178: FROM po_unique_identifier_control
1179: WHERE table_name = 'PO_REQUISITION_HEADERS'
1180: FOR UPDATE OF current_max_unique_identifier;
1181:
1182: -- Get unique requisition_header_id
1183: CURSOR req_header_id_cur IS

Line 1184: SELECT po_requisition_headers_s.nextval

1180: FOR UPDATE OF current_max_unique_identifier;
1181:
1182: -- Get unique requisition_header_id
1183: CURSOR req_header_id_cur IS
1184: SELECT po_requisition_headers_s.nextval
1185: FROM sys.dual;
1186:
1187: -- Get unique requisition_line_id
1188: CURSOR req_line_id_cur IS

Line 1966: FROM po_requisition_headers

1962: SELECT 1 INTO l_dummy
1963: FROM DUAL
1964: WHERE NOT EXISTS
1965: ( SELECT 1
1966: FROM po_requisition_headers
1967: WHERE Segment1 = l_header_rec.requisition_number)
1968: AND NOT EXISTS
1969: ( SELECT 1
1970: FROM po_history_requisitions phr

Line 1985: 'Inserting data into PO_REQUISITION_HEADERS');

1981:
1982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1984: 'csp.plsql.csp_parts_order.process_order',
1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;
1987: -- create approved requisition headers
1988: -- insert into PO_REQUISITION_HEADERS
1989: INSERT INTO PO_REQUISITION_HEADERS(

Line 1988: -- insert into PO_REQUISITION_HEADERS

1984: 'csp.plsql.csp_parts_order.process_order',
1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;
1987: -- create approved requisition headers
1988: -- insert into PO_REQUISITION_HEADERS
1989: INSERT INTO PO_REQUISITION_HEADERS(
1990: org_id,
1991: requisition_header_id,
1992: preparer_id,

Line 1989: INSERT INTO PO_REQUISITION_HEADERS(

1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;
1987: -- create approved requisition headers
1988: -- insert into PO_REQUISITION_HEADERS
1989: INSERT INTO PO_REQUISITION_HEADERS(
1990: org_id,
1991: requisition_header_id,
1992: preparer_id,
1993: last_update_date,

Line 4376: WHERE table_name = 'PO_REQUISITION_HEADERS'

4372: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
4373: CURSOR req_number_cur IS
4374: SELECT to_char(current_max_unique_identifier + 1)
4375: FROM po_unique_identifier_control
4376: WHERE table_name = 'PO_REQUISITION_HEADERS'
4377: FOR UPDATE OF current_max_unique_identifier;
4378:
4379: -- Get unique requisition_header_id
4380: CURSOR req_header_id_cur IS

Line 4381: SELECT po_requisition_headers_s.nextval

4377: FOR UPDATE OF current_max_unique_identifier;
4378:
4379: -- Get unique requisition_header_id
4380: CURSOR req_header_id_cur IS
4381: SELECT po_requisition_headers_s.nextval
4382: FROM sys.dual;
4383:
4384: -- Get unique requisition_line_id
4385: CURSOR req_line_id_cur IS

Line 4498: FROM po_requisition_headers

4494: SELECT 1 INTO l_dummy
4495: FROM DUAL
4496: WHERE NOT EXISTS
4497: ( SELECT 1
4498: FROM po_requisition_headers
4499: WHERE Segment1 = l_header_rec.requisition_number)
4500: AND NOT EXISTS
4501: ( SELECT 1
4502: FROM po_history_requisitions phr