[Home] [Help]
113: );
114:
115: d_position := 20;
116:
117: -- insert a row into po_distributions_draft_all for a blanket
118: -- if encumbrance is required
119: insert_blk_dists_draft_all
120: (
121: p_headers => p_headers
1416: END IF;
1417:
1418: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1419:
1420: -- insert distribution rows into po_distributions_draft_all
1421: insert_po_dists_draft_all
1422: (
1423: p_dists => p_dists
1424: );
2115: --Name: insert_blk_dists_draft_all
2116: --Function:
2117: -- insert rows into po_distribution draft_all table;
2118: -- There are 2 cases when new rows will be inserted
2119: -- into po_distributions_draft_all table:
2120: -- 1. encumberance is required for new blanket: the
2121: -- attribute values will be read from
2122: -- po_headers_interface table
2123: -- 2. valid distribution rows exist in interface table:
2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2159: d_position := 10;
2160:
2161: FORALL i IN 1.. p_headers.rec_count
2162: INSERT INTO po_distributions_draft_all
2163: (
2164: draft_id,
2165: org_id,
2166: delete_flag,
2237: --Name: insert_po_dists_draft_all
2238: --Function:
2239: -- insert rows into po_distribution draft_all table;
2240: -- There are 2 cases when new rows will be inserted
2241: -- into po_distributions_draft_all table:
2242: -- 1. encumberance is required for new blanket: the
2243: -- attribute values will be read from
2244: -- po_headers_interface table
2245: -- 2. valid distribution rows exist in interface table:
2292: END IF;
2293:
2294: -- add distribution row from po_distributions_inteface table
2295: FORALL i IN 1..p_dists.rec_count
2296: INSERT INTO po_distributions_draft_all
2297: (
2298: draft_id,
2299: org_id,
2300: delete_flag,