[Home] [Help]
522: d_position := 70;
523: IF (PO_PDOI_PARAMS.g_request.document_type =
524: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
525: FORALL i IN 1..l_intf_line_id_tbl.COUNT
526: UPDATE po_distributions_interface
527: SET processing_id = PO_PDOI_PARAMS.g_processing_id
528: WHERE interface_line_id = l_intf_line_id_tbl(i);
529:
530: IF (PO_LOG.d_stmt) THEN
2236: SET shipment_type = 'PREPAYMENT',
2237: shipment_num = DECODE(shipment_num,NULL,1,shipment_num)
2238: WHERE interface_line_location_id = l_interface_line_location_id;
2239:
2240: UPDATE po_distributions_interface
2241: SET prevent_encumbrance_flag = 'Y'
2242: WHERE interface_line_id = (SELECT PLI.interface_line_id
2243: FROM po_lines_interface PLI
2244: WHERE PLI.rowid = l_rowid_tbl(i));
2277:
2278: d_position := 40;
2279:
2280: FORALL i IN 1..l_intf_line_tbl.COUNT
2281: UPDATE po_distributions_interface
2282: SET interface_line_location_id = l_intf_line_loc_tbl(i)
2283: WHERE interface_line_id = l_intf_line_tbl(i)
2284: AND interface_line_location_id IS NULL; -- PDOI for Complex PO Project
2285:
2291: /* PDOI for Complex PO Project -- START */
2292: FOR i IN 1..l_intf_line_tbl.COUNT LOOP
2293: DECLARE
2294: BEGIN
2295: UPDATE po_distributions_interface pd1
2296: SET (charge_account_id,
2297: charge_account_segment1,
2298: charge_account_segment2,
2299: charge_account_segment3,
2354: charge_account_segment27,
2355: charge_account_segment28,
2356: charge_account_segment29,
2357: charge_account_segment30
2358: FROM po_distributions_interface pd2
2359: WHERE pd2.interface_line_id = l_intf_line_tbl(i)
2360: AND (charge_account_id IS NOT NULL OR charge_account_segment1 IS NOT NULL)
2361: AND ROWNUM = 1)
2362: WHERE pd1.interface_line_id = l_intf_line_tbl(i)
2725: IF (PO_LOG.d_proc) THEN
2726: PO_LOG.proc_begin (d_module);
2727: END IF;
2728:
2729: INSERT INTO po_distributions_interface
2730: (
2731: interface_distribution_id,
2732: interface_header_id,
2733: interface_line_id,
2749: program_application_id,
2750: program_id,
2751: program_update_date
2752: )
2753: SELECT po_distributions_interface_s.nextval,
2754: PLL.interface_header_id,
2755: PLL.interface_line_id,
2756: PLL.interface_line_location_id,
2757: PLL.processing_id,
3038: IF (PO_LOG.d_proc) THEN
3039: PO_LOG.proc_begin (d_module);
3040: END IF;
3041:
3042: INSERT INTO po_distributions_interface
3043: (
3044: interface_distribution_id,
3045: interface_header_id,
3046: interface_line_id,
3063: program_application_id,
3064: program_id,
3065: program_update_date
3066: )
3067: SELECT po_distributions_interface_s.nextval,
3068: PLL.interface_header_id,
3069: PLL.interface_line_id,
3070: PLL.interface_line_location_id,
3071: PLL.processing_id,