APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 25: PROCEDURE insert_po_lines_draft_all

21: (
22: p_headers IN PO_PDOI_TYPES.headers_rec_type
23: );
24:
25: PROCEDURE insert_po_lines_draft_all
26: (
27: p_lines IN PO_PDOI_TYPES.lines_rec_type
28: );
29:

Line 237: -- insert lines into po_lines_draft_all

233: IF (PO_LOG.d_stmt) THEN
234: PO_LOG.stmt(d_module, d_position, 'insert lines into draft table');
235: END IF;
236:
237: -- insert lines into po_lines_draft_all
238: insert_po_lines_draft_all
239: (
240: p_lines => x_lines
241: );

Line 238: insert_po_lines_draft_all

234: PO_LOG.stmt(d_module, d_position, 'insert lines into draft table');
235: END IF;
236:
237: -- insert lines into po_lines_draft_all
238: insert_po_lines_draft_all
239: (
240: p_lines => x_lines
241: );
242:

Line 474: FROM po_lines_draft_all draft_lines,

470: draft_lines.category_id,
471: draft_lines.ip_category_id,
472: draft_lines.original_interface_line_id, -- bug5149827
473: items.allow_item_desc_update_flag
474: FROM po_lines_draft_all draft_lines,
475: mtl_system_items items
476: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
477: AND draft_lines.draft_id = l_draft_id_tbl(i)
478: AND draft_lines.item_id = items.inventory_item_id(+)

Line 1089: UPDATE po_lines_draft_all

1085: d_position := 280;
1086:
1087: -- 2. update draft table with all the changes
1088: FORALL i IN 1..l_po_line_id_tbl.COUNT
1089: UPDATE po_lines_draft_all
1090: SET unit_price = l_unit_price_tbl(i),
1091: unit_meas_lookup_code = l_unit_of_measure_tbl(i),
1092: item_description = l_item_desc_tbl(i),
1093: expiration_date = l_expiration_date_tbl(i),

Line 2500: --Name: insert_po_lines_draft_all

2496: END insert_po_dists_draft_all;
2497:
2498: -----------------------------------------------------------------------
2499: --Start of Comments
2500: --Name: insert_po_lines_draft_all
2501: --Function:
2502: -- insert new line attribute values into po_lines_draft_all
2503: --Parameters:
2504: --IN:

Line 2502: -- insert new line attribute values into po_lines_draft_all

2498: -----------------------------------------------------------------------
2499: --Start of Comments
2500: --Name: insert_po_lines_draft_all
2501: --Function:
2502: -- insert new line attribute values into po_lines_draft_all
2503: --Parameters:
2504: --IN:
2505: --p_lines
2506: -- record which contains processed line attributes in a batch;

Line 2514: PROCEDURE insert_po_lines_draft_all

2510: --IN OUT:
2511: --OUT:
2512: --End of Comments
2513: ------------------------------------------------------------------------
2514: PROCEDURE insert_po_lines_draft_all
2515: (
2516: p_lines IN PO_PDOI_TYPES.lines_rec_type
2517: ) IS
2518:

Line 2519: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_lines_draft_all';

2515: (
2516: p_lines IN PO_PDOI_TYPES.lines_rec_type
2517: ) IS
2518:
2519: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_lines_draft_all';
2520: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2521: d_position NUMBER;
2522:
2523: -- variables used to print debug message

Line 2553: INSERT INTO po_lines_draft_all

2549:
2550: d_position := 10;
2551:
2552: FORALL i IN 1..p_lines.rec_count
2553: INSERT INTO po_lines_draft_all
2554: (
2555: draft_id,
2556: org_id,
2557: delete_flag,

Line 2774: END insert_po_lines_draft_all;

2770: p_pkg_name => d_pkg_name,
2771: p_procedure_name => d_api_name || '.' || d_position
2772: );
2773: RAISE;
2774: END insert_po_lines_draft_all;
2775:
2776: -----------------------------------------------------------------------
2777: --Start of Comments
2778: --Name: insert_po_line_locs_draft_all