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_RCT_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 239: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

235: X_calling_sequence IN VARCHAR2)
236: IS
237: l_single_dist_flag varchar2(1) := 'N';
238: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
239: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
240: l_item_line_number ap_invoice_lines.line_number%TYPE;
241: l_amount_to_recoup ap_invoice_lines_all.amount%TYPE;
242: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
243: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

Line 480: FROM ap_invoice_distributions aid,

476: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
477: --end Bug 7483260
478: l_retained_amount,
479: -1 * l_retained_amount
480: FROM ap_invoice_distributions aid,
481: po_distributions pd,
482: po_line_locations pll,
483: rcv_transactions rtxn -- bug 5443250
484: WHERE aid.invoice_distribution_id = l_invoice_distribution_id

Line 932: ap_invoice_distributions_s.nextval

928: 'EXPENSE',PD.expenditure_organization_id,
929: NULL), --expenditure_organization_id
930: DECODE(PD.destination_type_code,
931: 'EXPENSE', PD.award_id), --award_id
932: ap_invoice_distributions_s.nextval
933: FROM po_distributions_ap_v PD,
934: rcv_transactions RT
935: WHERE PD.line_location_id = x_po_line_location_id
936: and Pd.line_location_id = RT.po_line_location_id

Line 950: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;

946: l_ret_status VARCHAR2(100);
947: l_msg_count NUMBER;
948: l_msg_data VARCHAR2(250);
949: l_total_amount NUMBER;
950: l_amount_invoiced ap_invoice_distributions_all.amount%TYPE;
951: l_matching_case VARCHAR2(2);
952: l_amount NUMBER;
953: l_quantity_invoiced NUMBER;
954: l_po_dist_ccid po_distributions.code_combination_id%TYPE;

Line 963: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

959: l_expenditure_type po_distributions.expenditure_type%TYPE;
960: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
961: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
962: i NUMBER;
963: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
964: l_unbuilt_flex VARCHAR2(240):='';
965: l_reason_unbuilt_flex VARCHAR2(2000):='';
966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

Line 966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

962: i NUMBER;
963: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
964: l_unbuilt_flex VARCHAR2(240):='';
965: l_reason_unbuilt_flex VARCHAR2(2000):='';
966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
968: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
969: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
970: l_rounding_index po_distributions.po_distribution_id%TYPE;

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

963: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
964: l_unbuilt_flex VARCHAR2(240):='';
965: l_reason_unbuilt_flex VARCHAR2(2000):='';
966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
968: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
969: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
970: l_rounding_index po_distributions.po_distribution_id%TYPE;
971: l_base_amount ap_invoice_distributions.base_amount%TYPE;

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

964: l_unbuilt_flex VARCHAR2(240):='';
965: l_reason_unbuilt_flex VARCHAR2(2000):='';
966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
968: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
969: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
970: l_rounding_index po_distributions.po_distribution_id%TYPE;
971: l_base_amount ap_invoice_distributions.base_amount%TYPE;
972: FLEX_OVERLAY_FAILED EXCEPTION;

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

965: l_reason_unbuilt_flex VARCHAR2(2000):='';
966: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
968: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
969: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
970: l_rounding_index po_distributions.po_distribution_id%TYPE;
971: l_base_amount ap_invoice_distributions.base_amount%TYPE;
972: FLEX_OVERLAY_FAILED EXCEPTION;
973: current_calling_sequence VARCHAR2(2000);

Line 971: l_base_amount ap_invoice_distributions.base_amount%TYPE;

967: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
968: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
969: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
970: l_rounding_index po_distributions.po_distribution_id%TYPE;
971: l_base_amount ap_invoice_distributions.base_amount%TYPE;
972: FLEX_OVERLAY_FAILED EXCEPTION;
973: current_calling_sequence VARCHAR2(2000);
974: l_debug_info VARCHAR2(2000);
975: l_api_name VARCHAR2(50);

Line 1150: ap_invoice_distributions_s.nextval

1146: award_id,
1147: expenditure_type,
1148: expenditure_item_date,
1149: expenditure_organization_id,
1150: ap_invoice_distributions_s.nextval
1151: INTO x_dist_tab(i).accrue_on_receipt_flag,
1152: x_dist_tab(i).po_ccid,
1153: x_dist_tab(i).project_id,
1154: x_dist_tab(i).task_id,

Line 2489: INSERT INTO ap_invoice_distributions (

2485: FOR i in nvl(X_Dist_tab.FIRST, 0) .. nvl(X_Dist_tab.LAST, 0) LOOP
2486:
2487: IF (x_dist_tab.exists(i)) THEN
2488:
2489: INSERT INTO ap_invoice_distributions (
2490: batch_id,
2491: invoice_id,
2492: invoice_line_number,
2493: invoice_distribution_id,

Line 3220: ap_invoice_distributions_s.nextval

3216: round((x_correction_amount * aid.amount/ail.amount)
3217: /g_min_acct_unit) * g_min_acct_unit
3218: ) amount,
3219: aid.dist_code_combination_id,
3220: ap_invoice_distributions_s.nextval
3221: FROM ap_invoice_lines ail,
3222: ap_invoice_distributions aid
3223: WHERE ail.invoice_id = x_corrected_invoice_id
3224: AND ail.line_number = x_corrected_line_number

Line 3222: ap_invoice_distributions aid

3218: ) amount,
3219: aid.dist_code_combination_id,
3220: ap_invoice_distributions_s.nextval
3221: FROM ap_invoice_lines ail,
3222: ap_invoice_distributions aid
3223: WHERE ail.invoice_id = x_corrected_invoice_id
3224: AND ail.line_number = x_corrected_line_number
3225: AND aid.invoice_id = ail.invoice_id
3226: AND aid.invoice_line_number = ail.line_number

Line 3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;

3230: /*AND aid.line_type_lookup_code NOT IN ('PREPAY','AWT','RETAINAGE')
3231: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3232: OR aid.prepay_distribution_id IS NULL); */
3233:
3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3235: l_amount ap_invoice_distributions.amount%TYPE;

3231: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3232: OR aid.prepay_distribution_id IS NULL); */
3233:
3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;

3232: OR aid.prepay_distribution_id IS NULL); */
3233:
3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

3233:
3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

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

3234: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

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

3235: l_amount ap_invoice_distributions.amount%TYPE;
3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

Line 3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

3236: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3244: l_debug_info varchar2(2000);

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

3237: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3244: l_debug_info varchar2(2000);
3245: current_calling_sequence varchar2(2000);

Line 3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

3238: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3244: l_debug_info varchar2(2000);
3245: current_calling_sequence varchar2(2000);
3246:

Line 3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;

3239: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3240: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3241: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3242: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3243: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
3244: l_debug_info varchar2(2000);
3245: current_calling_sequence varchar2(2000);
3246:
3247: BEGIN

Line 3296: SELECT ap_invoice_distributions_s.nextval

3292: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3293:
3294: IF (x_corr_dist_tab.exists(i)) THEN
3295:
3296: SELECT ap_invoice_distributions_s.nextval
3297: INTO x_corr_dist_tab(i).invoice_distribution_id
3298: FROM DUAL;
3299:
3300: x_corr_dist_tab(i).pa_quantity := Null;

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

3844: X_Total_Amount IN NUMBER,
3845: X_Calling_Sequence IN VARCHAR2) IS
3846:
3847: i NUMBER;
3848: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
3849: l_debug_info VARCHAR2(2000);
3850: current_calling_sequence VARCHAR2(2000);
3851: l_api_name VARCHAR2(50);
3852:

Line 3861: INSERT INTO AP_INVOICE_DISTRIBUTIONS(

3857: FOR i in NVL(x_corr_dist_tab.FIRST,0) .. NVL(x_corr_dist_tab.LAST,0) LOOP
3858:
3859: IF (x_corr_dist_tab.exists(i)) THEN
3860:
3861: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
3862: batch_id,
3863: invoice_id,
3864: invoice_line_number,
3865: invoice_distribution_id,

Line 4182: ap_invoice_distributions aid,

4178: 'N', --accrual_posted_flag
4179: 'N', --cash_posted_flag
4180: 'N' --rcv_charge_addition_flag
4181: FROM ap_invoice_lines ail,
4182: ap_invoice_distributions aid,
4183: po_distributions pd
4184: WHERE ail.invoice_id = x_invoice_id
4185: AND ail.line_number = x_invoice_line_number
4186: AND aid.invoice_id = ail.corrected_inv_id