DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_DOCUMENT_TOTALS_PVT

Line 2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/

2617: FROM po_lines_merge_v
2618: WHERE po_line_id = p_po_line_id
2619: AND draft_id = p_draft_id;
2620:
2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2622: BEGIN
2623: l_line_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2624: p_doc_level_id => p_po_line_id,
2625: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,

Line 2623: l_line_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,

2619: AND draft_id = p_draft_id;
2620:
2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2622: BEGIN
2623: l_line_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2624: p_doc_level_id => p_po_line_id,
2625: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,
2626: p_draft_id => -1);
2627: EXCEPTION

Line 2625: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,

2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2622: BEGIN
2623: l_line_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2624: p_doc_level_id => p_po_line_id,
2625: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,
2626: p_draft_id => -1);
2627: EXCEPTION
2628: --Added No_Data_Found exception because, the above method will throw this excpetion when a new line is added in mod
2629: WHEN No_Data_Found THEN

Line 2690: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/

2686: FROM po_lines_draft_all
2687: WHERE po_line_id = p_po_line_id
2688: AND draft_id = p_draft_id;
2689:
2690: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2691: BEGIN
2692: l_mod_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2693: p_doc_level_id => p_po_line_id,
2694: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,

Line 2692: l_mod_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,

2688: AND draft_id = p_draft_id;
2689:
2690: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2691: BEGIN
2692: l_mod_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2693: p_doc_level_id => p_po_line_id,
2694: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,
2695: p_draft_id => p_draft_id);
2696:

Line 2694: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,

2690: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/
2691: BEGIN
2692: l_mod_amount := po_document_totals_pvt.getAmountOrdered(p_doc_level => po_document_totals_pvt.g_doc_level_LINE,
2693: p_doc_level_id => p_po_line_id,
2694: p_data_source => po_document_totals_pvt.g_data_source_TRANSACTION,
2695: p_draft_id => p_draft_id);
2696:
2697: EXCEPTION
2698: WHEN No_Data_Found THEN