eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 240: -- insert lines into po_lines_draft_all

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

Line 241: insert_po_lines_draft_all

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

Line 497: FROM po_lines_draft_all draft_lines,

493: -- Bug 13506679
494: draft_lines.un_number_id,
495: draft_lines.hazard_class_id
496: -- Bug 13506679
497: FROM po_lines_draft_all draft_lines,
498: mtl_system_items items
499: WHERE draft_lines.po_line_id = l_po_line_id_tbl(i)
500: AND draft_lines.draft_id = l_draft_id_tbl(i)
501: AND draft_lines.item_id = items.inventory_item_id(+)

Line 1180: UPDATE po_lines_draft_all

1176: d_position := 280;
1177:
1178: -- 2. update draft table with all the changes
1179: FORALL i IN 1..l_po_line_id_tbl.COUNT
1180: UPDATE po_lines_draft_all
1181: SET unit_price = l_unit_price_tbl(i),
1182: unit_meas_lookup_code = l_unit_of_measure_tbl(i),
1183: item_description = l_item_desc_tbl(i),
1184: expiration_date = l_expiration_date_tbl(i),

Line 2758: --Name: insert_po_lines_draft_all

2754: END insert_po_dists_draft_all;
2755:
2756: -----------------------------------------------------------------------
2757: --Start of Comments
2758: --Name: insert_po_lines_draft_all
2759: --Function:
2760: -- insert new line attribute values into po_lines_draft_all
2761: --Parameters:
2762: --IN:

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

2756: -----------------------------------------------------------------------
2757: --Start of Comments
2758: --Name: insert_po_lines_draft_all
2759: --Function:
2760: -- insert new line attribute values into po_lines_draft_all
2761: --Parameters:
2762: --IN:
2763: --p_lines
2764: -- record which contains processed line attributes in a batch;

Line 2772: PROCEDURE insert_po_lines_draft_all

2768: --IN OUT:
2769: --OUT:
2770: --End of Comments
2771: ------------------------------------------------------------------------
2772: PROCEDURE insert_po_lines_draft_all
2773: (
2774: p_lines IN PO_PDOI_TYPES.lines_rec_type
2775: ) IS
2776:

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

2773: (
2774: p_lines IN PO_PDOI_TYPES.lines_rec_type
2775: ) IS
2776:
2777: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_lines_draft_all';
2778: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2779: d_position NUMBER;
2780:
2781: -- variables used to print debug message

Line 2811: INSERT INTO po_lines_draft_all

2807:
2808: d_position := 10;
2809:
2810: FORALL i IN 1..p_lines.rec_count
2811: INSERT INTO po_lines_draft_all
2812: (
2813: draft_id,
2814: org_id,
2815: delete_flag,

Line 3101: END insert_po_lines_draft_all;

3097: p_pkg_name => d_pkg_name,
3098: p_procedure_name => d_api_name || '.' || d_position
3099: );
3100: RAISE;
3101: END insert_po_lines_draft_all;
3102:
3103: -----------------------------------------------------------------------
3104: --Start of Comments
3105: --Name: insert_po_line_locs_draft_all

Line 3287: (select unit_meas_lookup_code from po_lines_draft_all

3283: 0, -- quantity_billed
3284: 0, -- quantity_canceled
3285: Decode(p_line_locs.payment_type_tbl(i),'ADVANCE',p_line_locs.unit_of_measure_tbl(i),
3286: NVL(p_line_locs.unit_of_measure_tbl(i),
3287: (select unit_meas_lookup_code from po_lines_draft_all
3288: where po_line_id = p_line_locs.ln_po_line_id_tbl(i) --8565385
3289: AND draft_id = p_line_locs.draft_id_tbl(i)))),--Bug 12980629
3290: -- PDOI for Complex PO Project
3291: NULL, -- po_release_id,