DBA Data[Home] [Help]

APPS.PO_CORE_SV1 dependencies on PO_HEADERS

Line 18: FROM po_headers

14: l_temp VARCHAR2(10);
15:
16: CURSOR l_val_date_csr IS
17: SELECT 'valid'
18: FROM po_headers
19: WHERE po_header_id = x_po_header_id
20: AND (TRUNC(x_effective_date) BETWEEN
21: TRUNC(nvl(start_date,x_effective_date)) AND
22: TRUNC(nvl(end_date, x_effective_date)));

Line 181: -- PO_HEADERS -- For PO and PA

177: --Parameters:
178: --IN:
179: --p_table_name
180: -- Type of document to generate number for. Possible values are:
181: -- PO_HEADERS -- For PO and PA
182: -- PO_HEADERS_QUOTE -- For Quote
183: -- PO_HEADERS_RFQ -- For RFQ
184: -- PO_REQUISITION_HEADERS -- For Requisition
185: --p_org_id

Line 182: -- PO_HEADERS_QUOTE -- For Quote

178: --IN:
179: --p_table_name
180: -- Type of document to generate number for. Possible values are:
181: -- PO_HEADERS -- For PO and PA
182: -- PO_HEADERS_QUOTE -- For Quote
183: -- PO_HEADERS_RFQ -- For RFQ
184: -- PO_REQUISITION_HEADERS -- For Requisition
185: --p_org_id
186: -- Operating unit where the document belongs to

Line 183: -- PO_HEADERS_RFQ -- For RFQ

179: --p_table_name
180: -- Type of document to generate number for. Possible values are:
181: -- PO_HEADERS -- For PO and PA
182: -- PO_HEADERS_QUOTE -- For Quote
183: -- PO_HEADERS_RFQ -- For RFQ
184: -- PO_REQUISITION_HEADERS -- For Requisition
185: --p_org_id
186: -- Operating unit where the document belongs to
187: --IN OUT: