[Home] [Help]
65: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
66: l_parent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
67: l_grparent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;
68: l_grparent_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
69: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
70:
71: -- 12i Complex Work Procurement -------------------------------------------
72: l_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
73: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
539:
540: -- Get Procuring operating unit
541: SELECT org_id
542: INTO l_proc_operating_unit
543: FROM po_headers
544: WHERE po_header_id = p_po_header_id;
545:
546:
547: -- Loop Through all Parent Transactions
1069: l_accrual_flag VARCHAR2(1);
1070: l_counter NUMBER;
1071: l_procurement_org_flag VARCHAR2(1);
1072: l_trx_flow_header_id NUMBER;
1073: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1074: l_is_shared_proc VARCHAR2(1);
1075: /* Support for Landed Cost Management */
1076: l_lcm_flag VARCHAR2(1);
1077:
1143: l_accrual_flag,
1144: l_po_document_type_code,
1145: /* Support for Landed Cost Management */
1146: l_lcm_flag
1147: FROM po_headers POH,
1148: po_line_locations POLL,
1149: po_lines POL,
1150: rcv_transactions RT
1151: WHERE RT.transaction_id = p_rcv_transaction_id
1770: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1771: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1772: l_encumbrance_flag VARCHAR2(1);
1773: l_ussgl_option VARCHAR2(1);
1774: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1775: l_is_shared_proc VARCHAR2(1);
1776: /* Support for Landed Cost Management */
1777: l_lcm_flag VARCHAR2(1);
1778:
1833: l_accrual_flag,
1834: l_po_document_type_code,
1835: /* Support for Landed Cost Management */
1836: l_lcm_flag
1837: FROM po_headers POH,
1838: po_line_locations POLL,
1839: po_lines POL,
1840: po_distributions POD,
1841: rcv_transactions RT
2317: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2318: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2319: l_encumbrance_flag VARCHAR2(1);
2320: l_ussgl_option VARCHAR2(1);
2321: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2322: l_is_shared_proc VARCHAR2(1);
2323: /* Support for Landed Cost Management */
2324: l_lcm_flag VARCHAR2(1);
2325: BEGIN
2379: l_accrual_flag,
2380: l_po_document_type_code,
2381: /* Support for Landed Cost Management */
2382: l_lcm_flag
2383: FROM po_headers POH,
2384: po_line_locations POLL,
2385: po_lines POL,
2386: po_distributions POD,
2387: rcv_transactions RT
2859: l_procurement_org_flag VARCHAR2(1);
2860: l_trx_flow_header_id NUMBER;
2861:
2862:
2863: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2864: l_is_shared_proc VARCHAR2(1);
2865: /* Support for Landed Cost Management */
2866: l_lcm_flag VARCHAR2(1);
2867:
2934: l_accrual_flag,
2935: l_po_document_type_code,
2936: /* Support for Landed Cost Management */
2937: l_lcm_flag
2938: FROM po_headers POH,
2939: po_line_locations POLL,
2940: po_lines POL,
2941: rcv_transactions RT
2942: WHERE RT.transaction_id = p_rcv_transaction_id
3615: l_project_id,
3616: l_accrual_flag,
3617: /* Support for Landed Cost Management */
3618: l_lcm_flag
3619: FROM po_headers POH,
3620: po_line_locations POLL,
3621: po_lines POL,
3622: po_distributions POD,
3623: rcv_transactions RT