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_INVOICE_LINES_PKG dependencies on AP_INVOICES

Line 23: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;

19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_INVOICE_LINES_PKG.';
21:
22: --Bug14383132: Start
23: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
24: l_reverse_dist_count NUMBER := 0; --Bug14383132
25: l_sa_reverse_dist_count NUMBER:= 0; --Bug14383132
26:
27: FUNCTION TAX_DISTRIBUTIONS_EXIST

Line 44: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,

40: -- to be created by a distribution set and generates a pl/sql table
41: -- of distributions to be inserted IF need be by the calling module.
42: -----------------------------------------------------------------------
43: FUNCTION Generate_Dist_Tab_For_Dist_Set(
44: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
45: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,

Line 45: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

41: -- of distributions to be inserted IF need be by the calling module.
42: -----------------------------------------------------------------------
43: FUNCTION Generate_Dist_Tab_For_Dist_Set(
44: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
45: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,

Line 46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

42: -----------------------------------------------------------------------
43: FUNCTION Generate_Dist_Tab_For_Dist_Set(
44: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
45: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

Line 50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

46: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

Line 51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

47: X_line_source IN VARCHAR2,
48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

Line 52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

48: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
56: X_Error_Code OUT NOCOPY VARCHAR2,

Line 53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

49: X_dist_set_total_percent IN NUMBER,
50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
56: X_Error_Code OUT NOCOPY VARCHAR2,
57: X_Debug_Info OUT NOCOPY VARCHAR2,

Line 54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

50: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
51: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
52: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
53: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
54: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
55: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
56: X_Error_Code OUT NOCOPY VARCHAR2,
57: X_Debug_Info OUT NOCOPY VARCHAR2,
58: X_Debug_Context OUT NOCOPY VARCHAR2,

Line 144: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

140: l_dist_set_percent_number NUMBER;
141: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
142: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
143: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
144: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
145: l_status VARCHAR2(10);
146: l_industry VARCHAR2(10);
147: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
148: l_pa_installed VARCHAR2(1);

Line 147: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;

143: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
144: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
145: l_status VARCHAR2(10);
146: l_industry VARCHAR2(10);
147: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
148: l_pa_installed VARCHAR2(1);
149:
150: l_max_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
151: l_max_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;

Line 172: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

168: l_error_found VARCHAR2(1);
169: l_rounding_exists VARCHAR2(1) := 'N';
170: l_rounding_pa_qty_exists VARCHAR2(1) := 'N';
171: --For bug2938770
172: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
173: l_prepay_dist_code_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
174: --bugfix:5725904
175: l_sys_link_function VARCHAR2(2);
176: l_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 237: FROM ap_invoices AI,

233: SP.prepay_code_combination_id),
234: AI.invoice_type_lookup_code
235: INTO l_prepay_dist_code_ccid,
236: l_invoice_type_lookup_code
237: FROM ap_invoices AI,
238: po_vendor_sites PVS,
239: ap_system_parameters SP
240: WHERE AI.invoice_id = X_invoice_lines_rec.invoice_id
241: AND PVS.vendor_site_id = AI.vendor_site_id;

Line 431: AP_INVOICES_PKG.get_expenditure_item_date(

427: debug_info := 'Get expenditure item date IF null';
428: IF (X_dist_tab(i).project_id IS NOT NULL AND
429: X_dist_tab(i).expenditure_item_date IS NULL) THEN
430: X_dist_tab(i).expenditure_item_date :=
431: AP_INVOICES_PKG.get_expenditure_item_date(
432: X_invoice_lines_rec.invoice_id,
433: X_invoice_date,
434: X_invoice_lines_rec.accounting_date,
435: null,

Line 1215: FROM AP_INVOICES

1211:
1212: --ETAX: Invwkb
1213: CURSOR Invoice_Rec IS
1214: SELECT *
1215: FROM AP_INVOICES
1216: WHERE invoice_id = x_invoice_id;
1217:
1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

Line 1222: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1220: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1221:
1222: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1223:
1224: l_dist_set_percent_number NUMBER := 0;
1225: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
1226: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;

Line 1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;

1239: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
1240: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
1241: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1242: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

Line 1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

1240: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
1241: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1242: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;

1241: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1242: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

Line 1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

1242: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

1243: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1251: l_msg_application VARCHAR2(25);

Line 1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

1244: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1251: l_msg_application VARCHAR2(25);
1252: l_msg_count NUMBER;

Line 1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

1245: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1251: l_msg_application VARCHAR2(25);
1252: l_msg_count NUMBER;
1253: l_msg_data VARCHAR2(30);

Line 1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

1246: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1247: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1248: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1249: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1250: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1251: l_msg_application VARCHAR2(25);
1252: l_msg_count NUMBER;
1253: l_msg_data VARCHAR2(30);
1254: l_error_code VARCHAR2(4000); --Bug7539216

Line 1432: FROM ap_invoices AI

1428: l_exchange_date,
1429: l_exchange_rate_type,
1430: l_invoice_currency_code,
1431: l_set_of_books_id
1432: FROM ap_invoices AI
1433: WHERE invoice_id = X_invoice_id;
1434:
1435: EXCEPTION
1436: When no_data_found then

Line 1665: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

1661: l_round_dist_id_list distribution_id_tab_type;
1662: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1663: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1664: l_line_amount ap_invoice_lines.amount%TYPE;
1665: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1666: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
1667: l_sum_base_amt NUMBER;
1668: l_sum_rpt_base_amt NUMBER;
1669:

Line 1666: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

1662: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1663: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1664: l_line_amount ap_invoice_lines.amount%TYPE;
1665: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1666: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
1667: l_sum_base_amt NUMBER;
1668: l_sum_rpt_base_amt NUMBER;
1669:
1670: current_calling_sequence VARCHAR2(2000);

Line 1679: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL

1675: SELECT decode(x_reporting_ledger_id, null, AIL.base_amount, null),
1676: AIL.amount, -- line_amount
1677: AI.invoice_currency_code, -- invoice_currency_code
1678: ASP.base_currency_code -- base_currency_code
1679: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL
1680: WHERE AI.invoice_id = X_invoice_id
1681: AND AIL.invoice_id = AI.invoice_id
1682: AND AIL.line_number = X_line_number
1683: AND ASP.org_id = AI.org_id;

Line 1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

1863:
1864: l_invoice_validation_status VARCHAR2(100);
1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;

Line 1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

1864: l_invoice_validation_status VARCHAR2(100);
1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;
1872:

Line 1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

1865: l_success BOOLEAN;
1866: l_error_code VARCHAR2(4000);
1867: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1868: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1869: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1870: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1871: l_tax_distribution_count NUMBER;
1872:
1873: --Contract Payments

Line 2018: l_recouped_amount ap_invoices_all.invoice_amount%type;

2014: FROM ap_invoice_distributions_all aid
2015: WHERE aid.invoice_id = p_line_rec.invoice_id;
2016:
2017: --bugfix:5638822
2018: l_recouped_amount ap_invoices_all.invoice_amount%type;
2019: l_amount_paid number;
2020: l_error_message varchar2(4000);
2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2022: l_amount_remaining number;

Line 2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;

2017: --bugfix:5638822
2018: l_recouped_amount ap_invoices_all.invoice_amount%type;
2019: l_amount_paid number;
2020: l_error_message varchar2(4000);
2021: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
2022: l_amount_remaining number;
2023:
2024: TYPE r_line_number_arr IS TABLE OF ap_invoice_distributions.distribution_line_number%TYPE; /*Bug 9841966*/
2025: TYPE r_ppay_incl_arr IS TABLE OF ap_invoice_lines_all.invoice_includes_prepay_flag%TYPE; /*Bug 9841966*/

Line 2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

2027: --bugfix:5697764
2028: l_tax_line_number r_line_number_arr; --number; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:

Line 2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;

2028: l_tax_line_number r_line_number_arr; --number; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:
2036: --bug 8361741

Line 2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;

2029: l_unapplied_tax_amount number;
2030: l_unapplied_tax_amt_pay_curr number;
2031: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
2032: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
2033: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
2034: l_prepay_included r_ppay_incl_arr;--ap_invoice_lines_all.invoice_includes_prepay_flag%type; /*Bug 9841966: Commented old datatype and changed it to pl/sql array*/
2035:
2036: --bug 8361741
2037: l_itm_dist_count NUMBER;

Line 2250: and zx_dist.entity_code = 'AP_INVOICES'

2246: zx_rec_nrec_dist zx_dist
2247: where tax_dist.invoice_id = c_invoice_id
2248: and tax_dist.invoice_id = zx_dist.trx_id
2249: and zx_dist.application_id = 200
2250: and zx_dist.entity_code = 'AP_INVOICES'
2251: and zx_dist.event_class_code IN ('STANDARD INVOICES',
2252: 'PREPAYMENT INVOICES',
2253: 'EXPENSE REPORTS')
2254: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')

Line 2458: and zx_dist.entity_code = 'AP_INVOICES'

2454: zx_rec_nrec_dist zx_dist
2455: where tax_dist.invoice_id = c_invoice_id
2456: and tax_dist.invoice_id = zx_dist.trx_id
2457: and zx_dist.application_id = 200
2458: and zx_dist.entity_code = 'AP_INVOICES'
2459: and zx_dist.event_class_code IN ('STANDARD INVOICES',
2460: 'PREPAYMENT INVOICES',
2461: 'EXPENSE REPORTS')
2462: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')

Line 2554: FROM ap_invoices ai,

2550: l_invoice_rec.vendor_id,
2551: l_invoice_rec.invoice_date,
2552: l_invoice_rec.disc_is_inv_less_tax_flag,
2553: l_invoice_rec.exclude_freight_from_discount
2554: FROM ap_invoices ai,
2555: ap_system_parameters_all asp
2556: WHERE invoice_id = p_line_rec.invoice_id
2557: AND ai.org_id = asp.org_id;
2558:

Line 3779: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(

3775: --as the call is already done in CANCEL package before control comes here.
3776: --The reason the call being placed
3777: IF (l_ok_to_discard) THEN
3778:
3779: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
3780: l_invoice_id => p_line_rec.invoice_id,
3781: l_invoice_amount => l_invoice_amount,
3782: l_payment_status_flag => l_payment_status_flag,
3783: l_invoice_type_lookup_code => l_invoice_type_lookup_code );

Line 4132: /* UPDATE ap_invoices

4128: END IF;
4129:
4130: --Commented below update for bug #8928639
4131:
4132: /* UPDATE ap_invoices
4133: SET amount_paid = nvl(amount_paid,0) - abs(l_recouped_amount) ,
4134: payment_status_flag =
4135: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),
4136: last_update_date = SYSDATE,

Line 4135: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),

4131:
4132: /* UPDATE ap_invoices
4133: SET amount_paid = nvl(amount_paid,0) - abs(l_recouped_amount) ,
4134: payment_status_flag =
4135: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),
4136: last_update_date = SYSDATE,
4137: last_updated_by = fnd_global.user_id,
4138: last_update_login = p_line_rec.last_update_login
4139: WHERE invoice_id = p_line_rec.invoice_id; */

Line 4234: FROM AP_INVOICES

4230: --Bug 4352723 - Added the following select to get Invoice Header
4231: --GL date to be used for Invoice cancellation event and dists
4232: SELECT gl_date
4233: INTO l_open_gl_date
4234: FROM AP_INVOICES
4235: WHERE invoice_id = P_Line_Rec.invoice_id;
4236:
4237:
4238: AP_ACCOUNTING_EVENTS_PKG.Create_Events (