APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 19: ** - Insert into po_lines_draft_all

15: ** - Fetch data from po_lines_interface
16: ** - Derive Line
17: ** - Default Line
18: ** - Validate Line
19: ** - Insert into po_lines_draft_all
20: **
21: ** The procedures of this package are called from PO_AUTOCREATE_MAINPROC_PVT.process_line
22: **
23: ** HISTORY

Line 1965: FROM PO_LINES_draft_all

1961: x_po_unit_price,
1962: x_po_transaction_reason_code,
1963: x_price_break_lookup_code,
1964: l_manual_price_change_flag
1965: FROM PO_LINES_draft_all
1966: WHERE PO_HEADER_ID = po_autocreate_params.g_po_header_id
1967: AND LINE_NUM = p_lines.line_num_tbl(i)
1968: AND draft_id =po_autocreate_params.g_draft_id;
1969:

Line 2879: INTO po_lines_draft_all

2875: ||' Unit Price : ' || p_lines.unit_price_tbl(i));
2876: END IF;
2877: l_progress := '520';
2878: INSERT
2879: INTO po_lines_draft_all
2880: (
2881: draft_id,
2882: po_line_id,
2883: last_update_date,

Line 3155: from po_lines_draft_all pl --

3151: l_progress := '540';
3152: BEGIN
3153: select pl.quantity
3154: into l_db_quantity
3155: from po_lines_draft_all pl --
3156: where pl.po_line_id = x_po_line_id
3157: AND pl.draft_id=po_autocreate_params.g_draft_id;
3158:
3159: IF g_debug_stmt

Line 3292: UPDATE po_lines_draft_all

3288: IF (x_unit_price = 0) THEN
3289: x_unit_price := NULL;
3290: END IF;
3291:
3292: UPDATE po_lines_draft_all
3293: SET unit_price= nvl(x_unit_price, unit_price)
3294: ,base_unit_price = nvl(l_base_unit_price, base_unit_price)
3295: ,from_line_location_id = l_price_break_id
3296:

Line 3335: UPDATE po_lines_draft_all plda

3331: /* CLM Autocreate grouping start
3332: The quantity/amount should be the aggregate of all the matched lines quantity/amount
3333: */
3334:
3335: UPDATE po_lines_draft_all plda
3336: SET plda.quantity = Decode(plda.matching_basis,
3337: 'QUANTITY', (nvl(plda.quantity,0) + nvl(x_quantity,0)),
3338: plda.quantity)
3339: ,plda.amount = Decode(plda.matching_basis,

Line 3366: UPDATE po_lines_draft_all

3362: p_lines.item_id_tbl(i),
3363: x_secondary_unit_def,
3364: x_secondary_quantity_def) ;
3365:
3366: UPDATE po_lines_draft_all
3367: SET secondary_quantity = x_secondary_quantity_def,
3368: secondary_unit_of_measure = x_secondary_unit_def
3369: WHERE po_line_id = x_po_line_id
3370: AND draft_id=po_autocreate_params.g_draft_id;

Line 3383: UPDATE po_Lines_draft_all

3379: END IF;
3380:
3381: -- Added for Linking Requisition to modification project
3382: IF (po_autocreate_params.g_is_clm_po ='Y' AND po_autocreate_params.g_process_code = 'ADD_FUNDS') THEN
3383: UPDATE po_Lines_draft_all
3384: SET clm_exercised_flag = 'Y',
3385: clm_exercised_date = SYSDATE,
3386: change_status = 'UPDATE'
3387: WHERE po_line_id = x_po_line_id