APPS.IGIPMSMD dependencies on IGI_MPP_AP_INVOICE_DISTS

Line 41: FROM igi_mpp_ap_invoice_dists ext_dist

37: , cp_distribution_line_number in number
38: )
39: IS
40: SELECT ext_dist.*
41: FROM igi_mpp_ap_invoice_dists ext_dist
42: WHERE ext_dist.distribution_line_number = cp_distribution_line_number
43: AND ext_dist.invoice_id = cp_invoice_id
44: ;
45:

Line 165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;

161: l_currency_code ap_invoices_all.invoice_currency_code%TYPE := NULL;
162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;
163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;
164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;
165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;
166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;
167:
168: FUNCTION isVariableDuration ( fp_accounting_rule_id in number)
169: RETURN BOOLEAN IS

Line 166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;

162: l_amount ap_invoice_distributions_all.amount%TYPE := NULL;
163: l_running_amount ap_invoice_distributions_all.amount%TYPE := NULL;
164: l_total_amount ap_invoice_distributions_all.amount%TYPE := NULL;
165: l_mpp_dist_line_num igi_mpp_ap_invoice_dists_det.mpp_dist_line_number%TYPE;
166: l_period_name igi_mpp_ap_invoice_dists_det.period_name%TYPE;
167:
168: FUNCTION isVariableDuration ( fp_accounting_rule_id in number)
169: RETURN BOOLEAN IS
170: CURSOR c_exist is

Line 216: INSERT INTO igi_mpp_ap_invoice_dists_det

212: '>> >> ** Mpp dist amount '|| p_amount );
213: END IF;
214: --bug 3199481 fnd logging changes: sdixit: end block
215:
216: INSERT INTO igi_mpp_ap_invoice_dists_det
217: ( mpp_dist_line_number
218: , distribution_line_number
219: , invoice_id
220: , last_updated_by

Line 563: UPDATE igi_mpp_ap_invoice_dists_det

559: END IF;
560: --bug 3199481 fnd logging changes: sdixit: end block
561: IF l_running_amount <> 0 AND l_mpp_dist_line_num <> 0 THEN
562:
563: UPDATE igi_mpp_ap_invoice_dists_det
564: SET amount = amount + l_running_amount
565: WHERE invoice_id = l_dist.invoice_id
566: AND distribution_line_number = l_dist.distribution_line_number
567: AND mpp_dist_line_number = l_mpp_dist_line_num