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.

[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on AP_INVOICES

Line 30: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,

26: -- to be created by a distribution set and generates a pl/sql table
27: -- of distributions to be inserted IF need be by the calling module.
28: -----------------------------------------------------------------------
29: FUNCTION Generate_Dist_Tab_For_Dist_Set(
30: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
31: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
32: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
33: X_line_source IN VARCHAR2,
34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,

Line 31: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

27: -- of distributions to be inserted IF need be by the calling module.
28: -----------------------------------------------------------------------
29: FUNCTION Generate_Dist_Tab_For_Dist_Set(
30: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
31: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
32: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
33: X_line_source IN VARCHAR2,
34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
35: X_dist_set_total_percent IN NUMBER,

Line 32: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

28: -----------------------------------------------------------------------
29: FUNCTION Generate_Dist_Tab_For_Dist_Set(
30: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
31: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
32: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
33: X_line_source IN VARCHAR2,
34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
35: X_dist_set_total_percent IN NUMBER,
36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

Line 36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

32: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
33: X_line_source IN VARCHAR2,
34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
35: X_dist_set_total_percent IN NUMBER,
36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

Line 37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

33: X_line_source IN VARCHAR2,
34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
35: X_dist_set_total_percent IN NUMBER,
36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

Line 38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

34: X_dist_tab IN OUT NOCOPY AP_INVOICE_LINES_PKG.dist_tab_type,
35: X_dist_set_total_percent IN NUMBER,
36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
42: X_Error_Code OUT NOCOPY VARCHAR2,

Line 39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

35: X_dist_set_total_percent IN NUMBER,
36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
42: X_Error_Code OUT NOCOPY VARCHAR2,
43: X_Debug_Info OUT NOCOPY VARCHAR2,

Line 40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

36: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
37: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
38: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
39: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
40: X_base_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
41: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
42: X_Error_Code OUT NOCOPY VARCHAR2,
43: X_Debug_Info OUT NOCOPY VARCHAR2,
44: X_Debug_Context OUT NOCOPY VARCHAR2,

Line 130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
131: l_status VARCHAR2(10);
132: l_industry VARCHAR2(10);
133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
134: l_pa_installed VARCHAR2(1);

Line 133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;

129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
131: l_status VARCHAR2(10);
132: l_industry VARCHAR2(10);
133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
134: l_pa_installed VARCHAR2(1);
135:
136: l_max_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
137: l_max_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;

Line 158: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

154: l_error_found VARCHAR2(1);
155: l_rounding_exists VARCHAR2(1) := 'N';
156: l_rounding_pa_qty_exists VARCHAR2(1) := 'N';
157: --For bug2938770
158: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
159: l_prepay_dist_code_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
160: --bugfix:5725904
161: l_sys_link_function VARCHAR2(2);
162: l_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 214: FROM ap_invoices AI,

210: SP.prepay_code_combination_id),
211: AI.invoice_type_lookup_code
212: INTO l_prepay_dist_code_ccid,
213: l_invoice_type_lookup_code
214: FROM ap_invoices AI,
215: po_vendor_sites PVS,
216: ap_system_parameters SP
217: WHERE AI.invoice_id = X_invoice_lines_rec.invoice_id
218: AND PVS.vendor_site_id = AI.vendor_site_id;

Line 402: AP_INVOICES_PKG.get_expenditure_item_date(

398: debug_info := 'Get expenditure item date IF null';
399: IF (X_dist_tab(i).project_id IS NOT NULL AND
400: X_dist_tab(i).expenditure_item_date IS NULL) THEN
401: X_dist_tab(i).expenditure_item_date :=
402: AP_INVOICES_PKG.get_expenditure_item_date(
403: X_invoice_lines_rec.invoice_id,
404: X_invoice_date,
405: X_invoice_lines_rec.accounting_date,
406: null,

Line 1161: FROM AP_INVOICES

1157:
1158: --ETAX: Invwkb
1159: CURSOR Invoice_Rec IS
1160: SELECT *
1161: FROM AP_INVOICES
1162: WHERE invoice_id = x_invoice_id;
1163:
1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;

Line 1168: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1166: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1167:
1168: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1169:
1170: l_dist_set_percent_number NUMBER := 0;
1171: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
1172: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;

Line 1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;

1185: l_dist_set_attribute13 AP_DISTRIBUTION_SETS.ATTRIBUTE13%TYPE;
1186: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
1187: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1188: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

Line 1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

1186: l_dist_set_attribute14 AP_DISTRIBUTION_SETS.ATTRIBUTE14%TYPE;
1187: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1188: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;

1187: l_dist_set_attribute15 AP_DISTRIBUTION_SETS.ATTRIBUTE15%TYPE;
1188: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

Line 1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

1188: l_inactive_date AP_DISTRIBUTION_SETS.INACTIVE_DATE%TYPE;
1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

1189: l_batch_id AP_INVOICES.BATCH_ID%TYPE;
1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1197: l_msg_application VARCHAR2(25);

Line 1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

1190: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1197: l_msg_application VARCHAR2(25);
1198: l_msg_count NUMBER;

Line 1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

1191: l_vendor_site_id AP_INVOICES.VENDOR_SITE_ID%TYPE;
1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1197: l_msg_application VARCHAR2(25);
1198: l_msg_count NUMBER;
1199: l_msg_data VARCHAR2(30);

Line 1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

1192: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
1193: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
1194: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
1195: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
1196: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1197: l_msg_application VARCHAR2(25);
1198: l_msg_count NUMBER;
1199: l_msg_data VARCHAR2(30);
1200: l_error_code VARCHAR2(30);

Line 1378: FROM ap_invoices AI

1374: l_exchange_date,
1375: l_exchange_rate_type,
1376: l_invoice_currency_code,
1377: l_set_of_books_id
1378: FROM ap_invoices AI
1379: WHERE invoice_id = X_invoice_id;
1380:
1381: EXCEPTION
1382: When no_data_found then

Line 1611: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

1607: l_round_dist_id_list distribution_id_tab_type;
1608: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1609: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1610: l_line_amount ap_invoice_lines.amount%TYPE;
1611: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1612: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
1613: l_sum_base_amt NUMBER;
1614: l_sum_rpt_base_amt NUMBER;
1615:

Line 1612: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

1608: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1609: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1610: l_line_amount ap_invoice_lines.amount%TYPE;
1611: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1612: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;
1613: l_sum_base_amt NUMBER;
1614: l_sum_rpt_base_amt NUMBER;
1615:
1616: current_calling_sequence VARCHAR2(2000);

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

1621: SELECT decode(x_reporting_ledger_id, null, AIL.base_amount, null),
1622: AIL.amount, -- line_amount
1623: AI.invoice_currency_code, -- invoice_currency_code
1624: ASP.base_currency_code -- base_currency_code
1625: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL
1626: WHERE AI.invoice_id = X_invoice_id
1627: AND AIL.invoice_id = AI.invoice_id
1628: AND AIL.line_number = X_line_number
1629: AND ASP.org_id = AI.org_id;

Line 1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;

1808:
1809: l_invoice_validation_status VARCHAR2(100);
1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;

Line 1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;

1809: l_invoice_validation_status VARCHAR2(100);
1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;
1817:

Line 1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

1810: l_success BOOLEAN;
1811: l_error_code VARCHAR2(4000);
1812: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
1813: l_payment_status_flag AP_INVOICES_ALL.PAYMENT_STATUS_FLAG%TYPE;
1814: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
1815: l_included_tax_amount AP_INVOICE_LINES_ALL.INCLUDED_TAX_AMOUNT%TYPE;
1816: l_tax_distribution_count NUMBER;
1817:
1818: --Contract Payments

Line 1935: l_recouped_amount ap_invoices_all.invoice_amount%type;

1931: FROM ap_invoice_distributions_all aid
1932: WHERE aid.invoice_id = p_line_rec.invoice_id;
1933:
1934: --bugfix:5638822
1935: l_recouped_amount ap_invoices_all.invoice_amount%type;
1936: l_amount_paid number;
1937: l_error_message varchar2(4000);
1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
1939: l_amount_remaining number;

Line 1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;

1934: --bugfix:5638822
1935: l_recouped_amount ap_invoices_all.invoice_amount%type;
1936: l_amount_paid number;
1937: l_error_message varchar2(4000);
1938: l_payment_currency_code ap_invoices_all.payment_currency_code%TYPE;
1939: l_amount_remaining number;
1940:
1941: --bugfix:5697764
1942: l_tax_line_number number;

Line 1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

1941: --bugfix:5697764
1942: l_tax_line_number number;
1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:

Line 1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;

1942: l_tax_line_number number;
1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:
1950: BEGIN

Line 1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;

1943: l_unapplied_tax_amount number;
1944: l_unapplied_tax_amt_pay_curr number;
1945: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1946: l_payment_cross_rate_date ap_invoices_all.payment_cross_rate_date%type;
1947: l_payment_cross_rate_type ap_invoices_all.payment_cross_rate_type%type;
1948: l_prepay_included ap_invoice_lines_all.invoice_includes_prepay_flag%type;
1949:
1950: BEGIN
1951:

Line 1986: FROM ap_invoices

1982: l_payment_currency_code,
1983: l_invoice_currency_code,
1984: l_payment_cross_rate_date,
1985: l_payment_cross_rate_type
1986: FROM ap_invoices
1987: WHERE invoice_id = p_line_rec.invoice_id;
1988:
1989: /*-----------------------------------------------------------------+
1990: | Step 0. If invoice line is AWT, undo withholding before |

Line 2166: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(

2162: --as the call is already done in CANCEL package before control comes here.
2163: --The reason the call being placed
2164: IF (l_ok_to_discard) THEN
2165:
2166: l_invoice_validation_status := ap_invoices_pkg.get_approval_status(
2167: l_invoice_id => p_line_rec.invoice_id,
2168: l_invoice_amount => l_invoice_amount,
2169: l_payment_status_flag => l_payment_status_flag,
2170: l_invoice_type_lookup_code => l_invoice_type_lookup_code );

Line 2514: UPDATE ap_invoices

2510: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2511: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Recouped Amount: '||l_recouped_amount);
2512: END IF;
2513:
2514: UPDATE ap_invoices
2515: SET amount_paid = nvl(amount_paid,0) - abs(l_recouped_amount) ,
2516: payment_status_flag =
2517: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),
2518: last_update_date = SYSDATE,

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

2513:
2514: UPDATE ap_invoices
2515: SET amount_paid = nvl(amount_paid,0) - abs(l_recouped_amount) ,
2516: payment_status_flag =
2517: AP_INVOICES_UTILITY_PKG.get_payment_status(p_line_rec.invoice_id ),
2518: last_update_date = SYSDATE,
2519: last_updated_by = fnd_global.user_id,
2520: last_update_login = p_line_rec.last_update_login
2521: WHERE invoice_id = p_line_rec.invoice_id;

Line 2625: FROM AP_INVOICES

2621: --Bug 4352723 - Added the following select to get Invoice Header
2622: --GL date to be used for Invoice cancellation event and dists
2623: SELECT gl_date
2624: INTO l_open_gl_date
2625: FROM AP_INVOICES
2626: WHERE invoice_id = P_Line_Rec.invoice_id;
2627:
2628:
2629: AP_ACCOUNTING_EVENTS_PKG.Create_Events (