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

Line 255: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

251:
252: l_single_dist_flag VARCHAR2(1) := 'N';
253: l_first NUMBER;
254: l_po_distribution_id po_distributions.po_distribution_id%TYPE := NULL;
255: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
256: l_item_line_number ap_invoice_lines.line_number%TYPE;
257: l_amount_to_recoup ap_invoice_lines.amount%TYPE;
258: l_line_amt_net_retainage ap_invoice_lines_all.amount%TYPE;
259: l_max_amount_to_recoup ap_invoice_lines_all.amount%TYPE;

Line 608: FROM ap_invoice_distributions aid,

604: nvl(ail.attribute15, decode(g_transfer_flag, 'Y', pll.attribute15, ail.attribute15)),
605: --end Bug 7483260
606: l_retained_amount,
607: -1 * l_retained_amount
608: FROM ap_invoice_distributions aid,
609: po_distributions pd,
610: po_line_locations pll,
611: rcv_transactions rcv
612: WHERE aid.invoice_distribution_id = l_invoice_distribution_id

Line 1100: ap_invoice_distributions_s.nextval

1096: 'EXPENSE',PD.expenditure_organization_id,
1097: NULL), --expenditure_organization_id
1098: DECODE(PD.destination_type_code,
1099: 'EXPENSE', PD.award_id), --award_id
1100: ap_invoice_distributions_s.nextval
1101: FROM po_distributions_ap_v PD,
1102: rcv_transactions RT
1103: WHERE PD.line_location_id = x_po_line_location_id
1104: and Pd.line_location_id = RT.po_line_location_id

Line 1138: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

1134: l_expenditure_type po_distributions.expenditure_type%TYPE;
1135: l_po_expenditure_item_date po_distributions.expenditure_item_date%TYPE;
1136: l_expenditure_organization_id po_distributions.expenditure_organization_id%TYPE;
1137: i NUMBER;
1138: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
1139: l_unbuilt_flex VARCHAR2(240):='';
1140: l_reason_unbuilt_flex VARCHAR2(2000):='';
1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;

Line 1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

1137: i NUMBER;
1138: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
1139: l_unbuilt_flex VARCHAR2(240):='';
1140: l_reason_unbuilt_flex VARCHAR2(2000):='';
1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
1143: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
1144: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
1145: l_rounding_index po_distributions.po_distribution_id%TYPE;

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

1138: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
1139: l_unbuilt_flex VARCHAR2(240):='';
1140: l_reason_unbuilt_flex VARCHAR2(2000):='';
1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
1143: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
1144: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
1145: l_rounding_index po_distributions.po_distribution_id%TYPE;
1146: l_base_amount ap_invoice_distributions.base_amount%TYPE;

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

1139: l_unbuilt_flex VARCHAR2(240):='';
1140: l_reason_unbuilt_flex VARCHAR2(2000):='';
1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
1143: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
1144: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
1145: l_rounding_index po_distributions.po_distribution_id%TYPE;
1146: l_base_amount ap_invoice_distributions.base_amount%TYPE;
1147: FLEX_OVERLAY_FAILED EXCEPTION;

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

1140: l_reason_unbuilt_flex VARCHAR2(2000):='';
1141: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
1143: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
1144: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
1145: l_rounding_index po_distributions.po_distribution_id%TYPE;
1146: l_base_amount ap_invoice_distributions.base_amount%TYPE;
1147: FLEX_OVERLAY_FAILED EXCEPTION;
1148: current_calling_sequence VARCHAR2(2000);

Line 1146: l_base_amount ap_invoice_distributions.base_amount%TYPE;

1142: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
1143: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
1144: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
1145: l_rounding_index po_distributions.po_distribution_id%TYPE;
1146: l_base_amount ap_invoice_distributions.base_amount%TYPE;
1147: FLEX_OVERLAY_FAILED EXCEPTION;
1148: current_calling_sequence VARCHAR2(2000);
1149: l_debug_info VARCHAR2(2000);
1150: l_api_name VARCHAR2(32);

Line 1256: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid

1252: 'ITEM_TO_SERVICE_RECEIPT',0,
1253: NVL(aid.corrected_quantity, 0) +
1254: NVL(aid.quantity_invoiced, 0))),0)
1255: INTO l_billed_txn_qty
1256: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid
1257: WHERE aid.PO_DISTRIBUTION_ID = l_po_distribution_id;
1258: END IF;
1259:
1260: l_billed_txn_qty := nvl(l_billed_txn_qty,0);

Line 1396: ap_invoice_distributions_s.nextval

1392: pd.award_id,
1393: pd.expenditure_type,
1394: pd.expenditure_item_date,
1395: pd.expenditure_organization_id,
1396: ap_invoice_distributions_s.nextval
1397: INTO x_dist_tab(i).po_ccid,
1398: x_dist_tab(i).accrue_on_receipt_flag,
1399: x_dist_tab(i).project_id,
1400: x_dist_tab(i).task_id,

Line 2702: l_rounded_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

2698: l_distribution_line_number NUMBER := 1;
2699: l_rounding_amount NUMBER;
2700: l_sum_prorated_amount NUMBER := 0;
2701: l_rounded_index NUMBER;
2702: l_rounded_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
2703: l_max_dist_amount NUMBER := 0;
2704: l_debug_info VARCHAR2(2000);
2705: current_calling_sequence VARCHAR2(2000);
2706: i NUMBER;

Line 2727: INSERT INTO ap_invoice_distributions (

2723: FOR i in nvl(X_Dist_tab.FIRST, 0) .. nvl(X_Dist_tab.LAST, 0) LOOP
2724:
2725: IF (x_dist_tab.exists(i)) THEN
2726:
2727: INSERT INTO ap_invoice_distributions (
2728: batch_id,
2729: invoice_id,
2730: invoice_line_number,
2731: invoice_distribution_id,

Line 3113: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

3109:
3110: l_distribution_line_number := l_distribution_line_number + 1;
3111:
3112: AP_DBI_PKG.Maintain_DBI_Summary
3113: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
3114: p_operation => 'I',
3115: p_key_value1 => x_invoice_id,
3116: p_key_value2 => x_dist_tab(i).invoice_distribution_id,
3117: p_calling_sequence => current_calling_sequence);

Line 3770: ap_invoice_distributions_s.nextval

3766: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3767: 'Y', pd.code_combination_id,
3768: aid1.dist_code_combination_id),
3769: pd.variance_account_id),
3770: ap_invoice_distributions_s.nextval
3771: FROM ap_invoice_lines ail,
3772: ap_invoice_distributions aid1,
3773: po_distributions pd,
3774: ap_invoice_distributions aid2

Line 3772: ap_invoice_distributions aid1,

3768: aid1.dist_code_combination_id),
3769: pd.variance_account_id),
3770: ap_invoice_distributions_s.nextval
3771: FROM ap_invoice_lines ail,
3772: ap_invoice_distributions aid1,
3773: po_distributions pd,
3774: ap_invoice_distributions aid2
3775: WHERE ail.invoice_id = x_corrected_invoice_id
3776: AND ail.line_number = x_corrected_line_number

Line 3774: ap_invoice_distributions aid2

3770: ap_invoice_distributions_s.nextval
3771: FROM ap_invoice_lines ail,
3772: ap_invoice_distributions aid1,
3773: po_distributions pd,
3774: ap_invoice_distributions aid2
3775: WHERE ail.invoice_id = x_corrected_invoice_id
3776: AND ail.line_number = x_corrected_line_number
3777: AND aid1.invoice_id = ail.invoice_id
3778: AND aid1.invoice_line_number = ail.line_number

Line 3814: ap_invoice_distributions_s.nextval

3810: ) amount,
3811: round((x_correction_quantity * pd.quantity_billed)/
3812: p_total_quantity_billed , 15) corrected_quantity,
3813: aid.dist_code_combination_id,
3814: ap_invoice_distributions_s.nextval
3815: FROM ap_invoice_distributions aid,
3816: ap_invoice_lines ail,
3817: po_distributions pd
3818: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3815: FROM ap_invoice_distributions aid,

3811: round((x_correction_quantity * pd.quantity_billed)/
3812: p_total_quantity_billed , 15) corrected_quantity,
3813: aid.dist_code_combination_id,
3814: ap_invoice_distributions_s.nextval
3815: FROM ap_invoice_distributions aid,
3816: ap_invoice_lines ail,
3817: po_distributions pd
3818: WHERE ail.invoice_id = x_corrected_invoice_id
3819: AND ail.line_number = x_corrected_line_number

Line 3830: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;

3826: /*AND aid.line_type_lookup_code NOT IN ('PREPAY','AWT','RETAINAGE')
3827: AND (aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX')
3828: OR aid.prepay_distribution_id IS NULL); */
3829:
3830: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3831: l_po_dist_id po_distributions.po_distribution_id%TYPE;
3832: l_amount ap_invoice_distributions.amount%TYPE;
3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;

Line 3832: l_amount ap_invoice_distributions.amount%TYPE;

3828: OR aid.prepay_distribution_id IS NULL); */
3829:
3830: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3831: l_po_dist_id po_distributions.po_distribution_id%TYPE;
3832: l_amount ap_invoice_distributions.amount%TYPE;
3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

Line 3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;

3829:
3830: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3831: l_po_dist_id po_distributions.po_distribution_id%TYPE;
3832: l_amount ap_invoice_distributions.amount%TYPE;
3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;

3830: l_corrected_inv_dist_id ap_invoice_distributions.corrected_invoice_dist_id%TYPE;
3831: l_po_dist_id po_distributions.po_distribution_id%TYPE;
3832: l_amount ap_invoice_distributions.amount%TYPE;
3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;

Line 3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

3832: l_amount ap_invoice_distributions.amount%TYPE;
3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

3833: l_corrected_quantity ap_invoice_distributions.corrected_quantity%TYPE;
3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;

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

3834: l_base_amount ap_invoice_distributions.base_amount%TYPE;
3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;

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

3835: l_total_quantity_billed po_distributions.quantity_billed%TYPE;
3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3843: l_debug_info varchar2(2000);

Line 3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;

3836: l_dist_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3843: l_debug_info varchar2(2000);
3844: current_calling_sequence varchar2(2000);

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

3837: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3843: l_debug_info varchar2(2000);
3844: current_calling_sequence varchar2(2000);
3845: l_api_name varchar2(4000);

Line 3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;

3838: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
3839: l_sum_prorated_amount ap_invoice_distributions.amount%TYPE := 0;
3840: l_rounding_index ap_invoice_distributions.invoice_distribution_id%TYPE;
3841: l_sum_dist_base_amount ap_invoice_distributions.base_amount%TYPE := 0;
3842: l_price_variance ap_invoice_distributions.amount%TYPE := 0;
3843: l_debug_info varchar2(2000);
3844: current_calling_sequence varchar2(2000);
3845: l_api_name varchar2(4000);
3846:

Line 3864: FROM ap_invoice_distributions_all

3860: /*
3861: BEGIN
3862: SELECT nvl(sum(amount),0) -- Bug 5629985. Added the NVL
3863: INTO l_price_variance
3864: FROM ap_invoice_distributions_all
3865: WHERE invoice_id = x_corrected_invoice_id
3866: AND invoice_line_number = x_corrected_line_number
3867: AND line_type_lookup_code = 'IPV';
3868: EXCEPTION

Line 3914: ap_invoice_distributions aid

3910:
3911: SELECT sum(pd.quantity_billed)
3912: INTO l_total_quantity_billed
3913: FROM po_distributions pd,
3914: ap_invoice_distributions aid
3915: WHERE pd.po_distribution_id = aid.po_distribution_id
3916: AND aid.invoice_id = x_corrected_invoice_id
3917: AND aid.invoice_line_number = x_corrected_line_number
3918: -- Bug 5585744, Modified the condition below

Line 3980: SELECT ap_invoice_distributions_s.nextval

3976: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3977:
3978: IF (x_corr_dist_tab.exists(i)) THEN
3979:
3980: SELECT ap_invoice_distributions_s.nextval
3981: INTO x_corr_dist_tab(i).invoice_distribution_id
3982: FROM dual ;
3983:
3984: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;

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

4582: x_correction_type IN VARCHAR2,
4583: x_total_amount IN NUMBER,
4584: x_calling_sequence IN VARCHAR2) IS
4585:
4586: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
4587: l_rounded_dist_id ap_invoice_distributions.invoice_distribution_id%type := NULL;
4588: l_sum_amount_prorated ap_invoice_distributions.amount%TYPE := 0;
4589: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
4590: l_po_distribution_id po_distributions.po_distribution_id%TYPE;

Line 4587: l_rounded_dist_id ap_invoice_distributions.invoice_distribution_id%type := NULL;

4583: x_total_amount IN NUMBER,
4584: x_calling_sequence IN VARCHAR2) IS
4585:
4586: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
4587: l_rounded_dist_id ap_invoice_distributions.invoice_distribution_id%type := NULL;
4588: l_sum_amount_prorated ap_invoice_distributions.amount%TYPE := 0;
4589: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
4590: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
4591: l_debug_info VARCHAR2(2000);

Line 4588: l_sum_amount_prorated ap_invoice_distributions.amount%TYPE := 0;

4584: x_calling_sequence IN VARCHAR2) IS
4585:
4586: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
4587: l_rounded_dist_id ap_invoice_distributions.invoice_distribution_id%type := NULL;
4588: l_sum_amount_prorated ap_invoice_distributions.amount%TYPE := 0;
4589: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
4590: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
4591: l_debug_info VARCHAR2(2000);
4592: current_calling_sequence VARCHAR2(2000);

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

4585:
4586: l_distribution_line_number ap_invoice_distributions.distribution_line_number%type := 1;
4587: l_rounded_dist_id ap_invoice_distributions.invoice_distribution_id%type := NULL;
4588: l_sum_amount_prorated ap_invoice_distributions.amount%TYPE := 0;
4589: l_max_dist_amount ap_invoice_distributions.amount%TYPE := 0;
4590: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
4591: l_debug_info VARCHAR2(2000);
4592: current_calling_sequence VARCHAR2(2000);
4593: l_api_name VARCHAR2(50);

Line 4603: INSERT INTO AP_INVOICE_DISTRIBUTIONS(

4599: FOR I in NVL(x_corr_dist_tab.FIRST,0) .. NVL(x_corr_dist_tab.LAST,0) LOOP
4600:
4601: IF (x_corr_dist_tab.exists(i)) THEN
4602:
4603: INSERT INTO AP_INVOICE_DISTRIBUTIONS(
4604: batch_id,
4605: invoice_id,
4606: invoice_line_number,
4607: invoice_distribution_id,

Line 4928: ap_invoice_distributions aid,

4924: decode(g_system_allow_awt_flag,'Y',
4925: decode(g_site_allow_awt_flag,'Y',ail.pay_awt_group_id,NULL),
4926: NULL) --pay_awt_group_id Bug9689194
4927: FROM ap_invoice_lines ail,
4928: ap_invoice_distributions aid,
4929: po_distributions pd
4930: WHERE ail.invoice_id = x_invoice_id
4931: AND ail.line_number = x_invoice_line_number
4932: AND aid.invoice_id = ail.corrected_inv_id