APPS.AP_PREPAY_UTILS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_PKG

Line 601: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

597: l_bal_segment VARCHAR2(30);
598:
599: CURSOR c_prepay_dist IS
600: SELECT sum(nvl(prepay_amount_remaining,total_dist_amount)),
601: AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
602: aip.dist_code_combination_id, X_Sob_Id)
603: FROM ap_invoice_distributions aip
604: WHERE aip.invoice_id = X_Prepay_Id
605: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')

Line 608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

604: WHERE aip.invoice_id = X_Prepay_Id
605: AND aip.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
606: AND nvl(aip.reversal_flag,'N') <> 'Y'
607: AND nvl(aip.prepay_amount_remaining,amount) > 0
608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
609: aip.dist_code_combination_id, X_Sob_Id) IN
610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid

Line 610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

606: AND nvl(aip.reversal_flag,'N') <> 'Y'
607: AND nvl(aip.prepay_amount_remaining,amount) > 0
608: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
609: aip.dist_code_combination_id, X_Sob_Id) IN
610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

Line 614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

610: (SELECT AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
611: aid.dist_code_combination_id, X_Sob_Id)
612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
615: aip.dist_code_combination_id, X_Sob_Id)
616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
617: aip.dist_code_combination_id, X_Sob_Id);
618:

Line 616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

612: FROM ap_invoice_distributions aid
613: WHERE aid.invoice_id = X_Invoice_ID)
614: GROUP BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
615: aip.dist_code_combination_id, X_Sob_Id)
616: ORDER BY AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
617: aip.dist_code_combination_id, X_Sob_Id);
618:
619: BEGIN
620:

Line 635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(

631: FROM ap_invoice_distributions
632: WHERE invoice_id = X_Invoice_ID
633: AND line_type_lookup_code IN ('ITEM','PREPAY')
634: AND nvl(reversal_flag,'N') <> 'Y'
635: AND AP_INVOICE_DISTRIBUTIONS_PKG.get_balancing_segment_value(
636: dist_code_combination_id, X_Sob_Id)
637: = l_bal_segment;
638:
639: IF l_invoice_amount <> 0 THEN