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)));
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
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
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: