DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_ENCUMBRANCE_GT

Line 12584: -- Update NEW record in PO_ENCUMBRANCE_GT with the new

12580:
12581: -- re-initialize distributions list table
12582: l_distribution_id_tbl.delete;
12583:
12584: -- Update NEW record in PO_ENCUMBRANCE_GT with the new
12585: -- values
12586: l_progress := '006';
12587:
12588: IF g_debug_stmt THEN

Line 12623: -- update new values in PO_ENCUMBRANCE_GT

12619: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
12620: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
12621: END IF;
12622:
12623: -- update new values in PO_ENCUMBRANCE_GT
12624: UPDATE po_encumbrance_gt
12625: SET
12626: amount_ordered = l_new_amount,
12627: quantity_ordered = l_new_quantity,

Line 12624: UPDATE po_encumbrance_gt

12620: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
12621: END IF;
12622:
12623: -- update new values in PO_ENCUMBRANCE_GT
12624: UPDATE po_encumbrance_gt
12625: SET
12626: amount_ordered = l_new_amount,
12627: quantity_ordered = l_new_quantity,
12628: quantity_on_line = l_new_quantity, -- for bug14198621

Line 12637: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

12633: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
12634:
12635: l_progress := '009';
12636: IF g_debug_stmt THEN
12637: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');
12638: END IF;
12639:
12640:
12641:

Line 13453: -- Update NEW record in PO_ENCUMBRANCE_GT with the new

13449:
13450: -- re-initialize distributions list table
13451: l_distribution_id_tbl.delete;
13452:
13453: -- Update NEW record in PO_ENCUMBRANCE_GT with the new
13454: -- values
13455: l_progress := '006';
13456:
13457: IF g_debug_stmt THEN

Line 13491: -- update new values in PO_ENCUMBRANCE_GT

13487: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
13488: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
13489: END IF;
13490:
13491: -- update new values in PO_ENCUMBRANCE_GT
13492: UPDATE po_encumbrance_gt
13493: SET
13494: amount_ordered = l_new_amount,
13495: quantity_ordered = l_new_quantity,

Line 13492: UPDATE po_encumbrance_gt

13488: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
13489: END IF;
13490:
13491: -- update new values in PO_ENCUMBRANCE_GT
13492: UPDATE po_encumbrance_gt
13493: SET
13494: amount_ordered = l_new_amount,
13495: quantity_ordered = l_new_quantity,
13496: quantity_on_line = l_new_quantity, -- for bug14198621

Line 13505: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

13501: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
13502:
13503: l_progress := '009';
13504: IF g_debug_stmt THEN
13505: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');
13506: END IF;
13507:
13508: END LOOP;
13509: CLOSE l_dist_tax_csr;