APPS.PO_PDOI_MAINPROC_PVT dependencies on PO_LINES_DRAFT_ALL

Line 378: -- Modified Number of records in po_lines_draft_all

374: -- When there is Some change made by Cat. Admin/Supplier which is not yet sent to Buyer
375: -- Would lie in Drafts Table and the data state would be like this
376: -- 1 record in PO_DRAFT with status= 'DRAFT'
377: -- No data in po_headers_draft_all
378: -- Modified Number of records in po_lines_draft_all
379: -- At this stage, the Cat. admin should be able to query the agreement and
380: -- do further changes on it and send it for approval if he/she wants.
381: -- But After CLM changes in place,the Po_headers_merge_v has been modified and
382: -- the case when theer is a draft record existing with status=DRAFT and

Line 593: gather_stats('PO_LINES_DRAFT_ALL',d_api_name,d_position);

589: );
590: --Bug13343886
591: if PO_PDOI_CONSTANTS.g_GATHER_STATS = 'Y' THEN
592: d_position := 55;
593: gather_stats('PO_LINES_DRAFT_ALL',d_api_name,d_position);
594: END IF;
595: --Bug13343886
596:
597: -- delete all locations from po_line_locations_interface that are obsoleted

Line 1941: -- update amount or quantity value on po_lines_draft_all based

1937: IF (PO_PDOI_PARAMS.g_request.document_type =
1938: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1939: d_position := 130;
1940:
1941: -- update amount or quantity value on po_lines_draft_all based
1942: -- on the values on shipment for Standard PO.
1943: PO_PDOI_LINE_LOC_PROCESS_PVT.update_amount_quantity_on_line
1944: (
1945: p_po_line_id_tbl => l_processed_line_id_tbl,

Line 3161: 2. loop through each slin and stamp the group_line_id accordingly in po_lines_draft_all

3157: --------------------------------------------------------------------------------------------
3158:
3159: /*This procedure will
3160: 1. collect all slins in a cursor
3161: 2. loop through each slin and stamp the group_line_id accordingly in po_lines_draft_all
3162: */
3163: PROCEDURE set_clm_structure
3164: IS
3165:

Line 3174: FROM po_lines_draft_all draft_lines, po_lines_interface intf_lines,

3170: CURSOR c_slins
3171: IS
3172: SELECT intf_lines.group_line_id, draft_lines.po_line_id,
3173: draft_lines.draft_id, draft_lines.po_header_id
3174: FROM po_lines_draft_all draft_lines, po_lines_interface intf_lines,
3175: po_headers_interface intf_headers
3176: WHERE intf_lines.group_line_id IS NOT NULL
3177: AND intf_lines.interface_header_id =
3178: intf_headers.interface_header_id

Line 3193: UPDATE po_lines_draft_all

3189: END IF;
3190: --loop through all slins
3191: FOR l_rec IN c_slins
3192: LOOP
3193: UPDATE po_lines_draft_all
3194: SET group_line_id =
3195: (SELECT pld.po_line_id
3196: FROM po_lines_interface pli, po_lines_draft_all pld
3197: WHERE 1 = 1

Line 3196: FROM po_lines_interface pli, po_lines_draft_all pld

3192: LOOP
3193: UPDATE po_lines_draft_all
3194: SET group_line_id =
3195: (SELECT pld.po_line_id
3196: FROM po_lines_interface pli, po_lines_draft_all pld
3197: WHERE 1 = 1
3198: AND pld.po_header_id = l_rec.po_header_id
3199: AND pld.group_line_id IS NULL
3200: AND pld.line_num = pli.line_num

Line 3251: UPDATE po_lines_draft_all

3247: PO_LOG.stmt(d_module, d_position, 'clm base line num : ', l_po_line_id_tbl);
3248: END IF;
3249:
3250: FORALL i IN 1..l_clm_base_line_num_tbl.Count
3251: UPDATE po_lines_draft_all
3252: SET clm_base_line_num = ( SELECT po_line_id FROM po_lines_interface
3253: WHERE interface_line_id = l_clm_base_line_num_tbl(i)
3254: )
3255: WHERE l_clm_base_line_num_tbl(i) IS NOT NULL