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,
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
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
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,
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:
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