[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
1610: END IF;
1611:
1612: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1613:
1614: -- insert distribution rows into po_distributions_draft_all
1615: insert_po_dists_draft_all
1616: (
1617: p_dists => p_dists
1618: );
2351: --Name: insert_blk_dists_draft_all
2352: --Function:
2353: -- insert rows into po_distribution draft_all table;
2354: -- There are 2 cases when new rows will be inserted
2355: -- into po_distributions_draft_all table:
2356: -- 1. encumberance is required for new blanket: the
2357: -- attribute values will be read from
2358: -- po_headers_interface table
2359: -- 2. valid distribution rows exist in interface table:
2394: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
2395: d_position := 10;
2396:
2397: FORALL i IN 1.. p_headers.rec_count
2398: INSERT INTO po_distributions_draft_all
2399: (
2400: draft_id,
2401: org_id,
2402: delete_flag,
2473: --Name: insert_po_dists_draft_all
2474: --Function:
2475: -- insert rows into po_distribution draft_all table;
2476: -- There are 2 cases when new rows will be inserted
2477: -- into po_distributions_draft_all table:
2478: -- 1. encumberance is required for new blanket: the
2479: -- attribute values will be read from
2480: -- po_headers_interface table
2481: -- 2. valid distribution rows exist in interface table:
2528: END IF;
2529:
2530: -- add distribution row from po_distributions_inteface table
2531: FORALL i IN 1..p_dists.rec_count
2532: INSERT INTO po_distributions_draft_all
2533: (
2534: draft_id,
2535: org_id,
2536: delete_flag,