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,
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,
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,
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,
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,
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,
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,
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,
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);
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;
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;
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;
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,
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;
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;
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;
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;
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;
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;
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);
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;
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);
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);
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
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:
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);
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;
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;
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:
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
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;
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;
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:
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
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:
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 |
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 );
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,
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;
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 (