eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PO_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 227: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

223: X_calling_sequence IN VARCHAR2)
224: IS
225: l_single_dist_flag varchar2(1) := 'N';
226: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
227: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
228: l_item_line_number ap_invoice_lines.line_number%TYPE;
229: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
230: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
231: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

Line 482: FROM ap_invoice_distributions aid,

478: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
479: --end Bug 7483260
480: l_retained_amount,
481: -1 * l_retained_amount
482: FROM ap_invoice_distributions aid,
483: po_distributions pd,
484: po_line_locations pll
485: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
486: AND pd.po_distribution_id = aid.po_distribution_id

Line 937: ap_invoice_distributions_s.nextval

933: 'EXPENSE',PD.expenditure_organization_id,
934: NULL), --expenditure_organization_id
935: DECODE(PD.destination_type_code,
936: 'EXPENSE', PD.award_id), --award_id
937: ap_invoice_distributions_s.nextval
938: FROM po_distributions_ap_v PD
939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;

Line 943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;

939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;

Line 944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;

940:
941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
943: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
944: l_quantity_invoiced ap_invoice_distributions_all.quantity_invoiced%TYPE;
945: l_po_dist_ccid po_distributions.code_combination_id%TYPE;
946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';

Line 950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

946: l_accrue_on_receipt_flag po_distributions.accrue_on_receipt_flag%TYPE;
947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;

Line 951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

947: l_project_id po_distributions.project_id%TYPE;
948: l_unbuilt_flex varchar2(240):='';
949: l_reason_unbuilt_flex varchar2(2000):='';
950: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
951: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
952: l_task_id po_distributions.task_id%TYPE;
953: l_award_set_id po_distributions_all.award_id%TYPE;
954: l_expenditure_type po_distributions.expenditure_type%TYPE;
955: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;

Line 961: l_base_amount ap_invoice_distributions.base_amount%TYPE;

957: l_max_dist_amount number := 0;
958: l_sum_prorated_amount number := 0;
959: l_sum_dist_base_amount number := 0;
960: l_rounding_index po_distributions.po_distribution_id%TYPE;
961: l_base_amount ap_invoice_distributions.base_amount%TYPE;
962: flex_overlay_failed exception;
963: current_calling_sequence varchar2(2000);
964: l_debug_info varchar2(2000);
965:

Line 1062: ap_invoice_distributions_s.nextval

1058: award_id,
1059: expenditure_type,
1060: expenditure_item_date,
1061: expenditure_organization_id,
1062: ap_invoice_distributions_s.nextval
1063: INTO x_dist_tab(i).accrue_on_receipt_flag,
1064: x_dist_tab(i).po_ccid,
1065: x_dist_tab(i).project_id,
1066: x_dist_tab(i).task_id,

Line 2435: INSERT INTO ap_invoice_distributions (

2431: IF (x_dist_tab.exists(i)) THEN
2432:
2433: l_debug_info := 'x_dist_tab.invoice_distribution_id,dist_ccid is '||x_dist_tab(i).invoice_distribution_id||','||x_dist_tab(i).dist_ccid;
2434:
2435: INSERT INTO ap_invoice_distributions (
2436: batch_id,
2437: invoice_id,
2438: invoice_line_number,
2439: invoice_distribution_id,

Line 3155: ap_invoice_distributions_s.nextval

3151: round((x_correction_amount * aid.amount/ail.amount)
3152: /g_min_acct_unit) * g_min_acct_unit
3153: ) amount,
3154: aid.dist_code_combination_id,
3155: ap_invoice_distributions_s.nextval
3156: FROM ap_invoice_lines ail,
3157: ap_invoice_distributions aid
3158: WHERE ail.invoice_id = x_corrected_invoice_id
3159: AND ail.line_number = x_corrected_line_number

Line 3157: ap_invoice_distributions aid

3153: ) amount,
3154: aid.dist_code_combination_id,
3155: ap_invoice_distributions_s.nextval
3156: FROM ap_invoice_lines ail,
3157: ap_invoice_distributions aid
3158: WHERE ail.invoice_id = x_corrected_invoice_id
3159: AND ail.line_number = x_corrected_line_number
3160: AND aid.invoice_id = ail.invoice_id
3161: AND aid.invoice_line_number = ail.line_number

Line 3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;

3165: /*AND aid.line_type_lookup_code NOT IN ('PREPAY','AWT','RETAINAGE')
3166: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3167: OR aid.prepay_distribution_id IS NULL); */
3168:
3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3170: l_amount ap_invoice_distributions.amount%TYPE;

3166: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3167: OR aid.prepay_distribution_id IS NULL); */
3168:
3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;

3167: OR aid.prepay_distribution_id IS NULL); */
3168:
3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

3168:
3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

Line 3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

3169: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

Line 3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

3170: l_amount ap_invoice_distributions.amount%TYPE;
3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

Line 3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

3171: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3179: l_debug_info varchar2(2000);

Line 3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

3172: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3179: l_debug_info varchar2(2000);
3180: current_calling_sequence varchar2(2000);

Line 3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

3173: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3179: l_debug_info varchar2(2000);
3180: current_calling_sequence varchar2(2000);
3181:

Line 3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

3174: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3175: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3176: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3177: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3178: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3179: l_debug_info varchar2(2000);
3180: current_calling_sequence varchar2(2000);
3181:
3182: BEGIN

Line 3231: SELECT ap_invoice_distributions_s.nextval

3227: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3228:
3229: IF (x_corr_dist_tab.exists(i)) THEN
3230:
3231: SELECT ap_invoice_distributions_s.nextval
3232: INTO x_corr_dist_tab(i).invoice_distribution_id
3233: FROM DUAL;
3234:
3235: x_corr_dist_tab(i).corrected_quantity := Null;

Line 3828: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;

3824: x_total_amount IN NUMBER,
3825: x_calling_sequence IN VARCHAR2) IS
3826:
3827: i NUMBER;
3828: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
3829: l_debug_info VARCHAR2(2000);
3830: current_calling_sequence VARCHAR2(2000);
3831: l_api_name VARCHAR2(50);
3832:

Line 3842: INSERT INTO AP_INVOICE_DISTRIBUTIONS(

3838: FOR i in NVL(x_corr_dist_tab.FIRST,0) .. NVL(x_corr_dist_tab.LAST,0) LOOP
3839:
3840: IF (x_corr_dist_tab.exists(i)) THEN
3841:
3842: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
3843: batch_id,
3844: invoice_id,
3845: invoice_line_number,
3846: invoice_distribution_id,

Line 4164: ap_invoice_distributions aid,

4160: 'N', --accrual_posted_flag
4161: 'N', --cash_posted_flag
4162: 'N' --rcv_charge_addition_flag
4163: FROM ap_invoice_lines ail,
4164: ap_invoice_distributions aid,
4165: po_distributions pd
4166: WHERE ail.invoice_id = x_invoice_id
4167: AND ail.line_number = x_invoice_line_number
4168: AND aid.invoice_id = ail.corrected_inv_id