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_ISP_UTILITIES_PKG dependencies on AP_INVOICES_ALL

Line 88: from ap_invoices_all

84:
85: BEGIN
86: select invoice_type_lookup_code, set_of_books_id, gl_date
87: into l_invoice_type_lookup_code, l_set_of_books_id, l_gl_date
88: from ap_invoices_all
89: where invoice_id = p_invoice_id;
90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92: debug_info := 'no data found for the invoice id = '|| p_invoice_id;

Line 239: l_po_header_id ap_invoices_all.po_header_id%TYPE;

235: p_terms_date OUT NOCOPY DATE,
236: p_calling_sequence IN VARCHAR2)
237: IS
238:
239: l_po_header_id ap_invoices_all.po_header_id%TYPE;
240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;

Line 240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;

236: p_calling_sequence IN VARCHAR2)
237: IS
238:
239: l_po_header_id ap_invoices_all.po_header_id%TYPE;
240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;

Line 241: l_org_id ap_invoices_all.org_id%TYPE;

237: IS
238:
239: l_po_header_id ap_invoices_all.po_header_id%TYPE;
240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;

Line 242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

238:
239: l_po_header_id ap_invoices_all.po_header_id%TYPE;
240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;
246: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;

Line 243: l_invoice_date ap_invoices_all.invoice_date%TYPE;

239: l_po_header_id ap_invoices_all.po_header_id%TYPE;
240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;
246: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;
247: l_term_id_per_name NUMBER := Null;

Line 244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;

240: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;
246: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;
247: l_term_id_per_name NUMBER := Null;
248: l_start_date_active DATE;

Line 245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;

241: l_org_id ap_invoices_all.org_id%TYPE;
242: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
243: l_invoice_date ap_invoices_all.invoice_date%TYPE;
244: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
245: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;
246: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;
247: l_term_id_per_name NUMBER := Null;
248: l_start_date_active DATE;
249: l_end_date_active DATE;

Line 277: from ap_invoices_all

273: invoice_received_date, goods_received_date
274: into l_po_header_id, l_vendor_site_id, l_org_id,
275: l_invoice_type_lookup_code, l_invoice_date,
276: l_invoice_received_date, l_goods_received_date
277: from ap_invoices_all
278: where invoice_id = p_invoice_id;
279: EXCEPTION
280: WHEN NO_DATA_FOUND THEN
281: debug_info := 'no data found for the invoice id = '|| p_invoice_id;

Line 587: from ap_invoices_all

583: --the org and initialize, otherwise the code may not see the invoice on
584: --the moac synonyms and po will fail when they try to close the po.
585: select org_id
586: into l_org_id
587: from ap_invoices_all
588: where invoice_id = p_invoice_id;
589:
590: mo_global.set_policy_context('S',l_org_id);
591: fnd_global.apps_initialize (

Line 854: ap_invoices_all AI,

850: l_invoice_date,
851: l_invoice_description,
852: l_supplier_role
853: FROM
854: ap_invoices_all AI,
855: po_vendors PV,
856: po_vendor_sites_all PVS,
857: fnd_user u
858: WHERE

Line 1052: update ap_invoices_all

1048: --bug 9138008, Updating date columns after truncating time-stamp.
1049: --Also added updates for invoice_date and invoice_received_date as
1050: --terms_date is derived based on these two fields among others
1051:
1052: update ap_invoices_all
1053: set terms_id = l_terms_id,
1054: terms_date = trunc(l_terms_date),
1055: invoice_date = trunc(invoice_date),
1056: invoice_received_date = trunc(invoice_received_date)

Line 1133: update ap_invoices_all

1129: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1131: END IF;
1132:
1133: update ap_invoices_all
1134: set doc_category_code = l_doc_category_code,
1135: doc_sequence_value = l_db_sequence_value,
1136: doc_sequence_id = l_db_sequence_id
1137: where invoice_id = p_invoice_id;

Line 1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;

1165: p_sequence_numbering IN VARCHAR2,
1166: p_calling_sequence IN VARCHAR2)
1167:
1168: IS
1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

Line 1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

1166: p_calling_sequence IN VARCHAR2)
1167:
1168: IS
1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1174: l_curr_calling_sequence VARCHAR2(2000);

Line 1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

1167:
1168: IS
1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1174: l_curr_calling_sequence VARCHAR2(2000);
1175: l_debug_info VARCHAR2(500);

Line 1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

1168: IS
1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1174: l_curr_calling_sequence VARCHAR2(2000);
1175: l_debug_info VARCHAR2(500);
1176: l_api_name VARCHAR2(50);

Line 1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

1169: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1170: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1171: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1172: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1173: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1174: l_curr_calling_sequence VARCHAR2(2000);
1175: l_debug_info VARCHAR2(500);
1176: l_api_name VARCHAR2(50);
1177: l_hold_count NUMBER;

Line 1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1177: l_hold_count NUMBER;
1178: l_line_count NUMBER;
1179: l_line_total NUMBER;
1180: l_Sched_Hold_count NUMBER;
1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

Line 1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;

1178: l_line_count NUMBER;
1179: l_line_total NUMBER;
1180: l_Sched_Hold_count NUMBER;
1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1179: l_line_total NUMBER;
1180: l_Sched_Hold_count NUMBER;
1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1187: l_requester_id ap_invoices_all.requester_id%TYPE;

Line 1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;

1180: l_Sched_Hold_count NUMBER;
1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1187: l_requester_id ap_invoices_all.requester_id%TYPE;
1188:

Line 1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

1181: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1187: l_requester_id ap_invoices_all.requester_id%TYPE;
1188:
1189: --Bug 9239655

Line 1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;

1182: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1187: l_requester_id ap_invoices_all.requester_id%TYPE;
1188:
1189: --Bug 9239655
1190: l_exclude_freight_from_disc VARCHAR2(1) :='N';

Line 1187: l_requester_id ap_invoices_all.requester_id%TYPE;

1183: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1184: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1185: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1186: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1187: l_requester_id ap_invoices_all.requester_id%TYPE;
1188:
1189: --Bug 9239655
1190: l_exclude_freight_from_disc VARCHAR2(1) :='N';
1191: l_exclude_tax_from_disc VARCHAR2(1) :='N';

Line 1242: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)

1238: SELECT decode(assa.exclude_freight_from_discount,NULL,nvl(aps.exclude_freight_from_discount,'N'),assa.exclude_freight_from_discount)
1239: INTO l_exclude_freight_from_disc
1240: FROM ap_suppliers aps,
1241: ap_supplier_sites_all assa
1242: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1243: AND assa.vendor_id = aps.vendor_id
1244: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1245:
1246: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')

Line 1244: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);

1240: FROM ap_suppliers aps,
1241: ap_supplier_sites_all assa
1242: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1243: AND assa.vendor_id = aps.vendor_id
1244: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1245:
1246: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1247: INTO l_exclude_tax_from_disc
1248: FROM ap_system_parameters asp

Line 1249: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);

1245:
1246: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1247: INTO l_exclude_tax_from_disc
1248: FROM ap_system_parameters asp
1249: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN NULL;
1253: END;

Line 1258: update ap_invoices_all ai

1254:
1255: -- don't do anything if lines don't exist
1256: /*Bug 14386893*/
1257: if (l_lines_cnt > 0) then
1258: update ap_invoices_all ai
1259: set invoice_amount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1260: amount_applicable_to_discount = l_item_sum + l_misc_sum + l_retained_sum
1261: /* Bug 9239655: Added conditions for adding Freight and Tax lines sum to
1262: amount_applicable_to_discount */

Line 1328: FROM ap_invoices_all ai,

1324: l_default_exchange_Rate_type,
1325: l_exchange_rate,
1326: l_exchange_date,
1327: l_requester_id
1328: FROM ap_invoices_all ai,
1329: ap_system_parameters_all asp
1330: WHERE ai.org_id = asp.org_id
1331: and ai.invoice_id = p_invoice_id;
1332:

Line 1347: UPDATE ap_invoices_all

1343: fnd_msg_pub.add;
1344: RAISE NULL_EXCHG_RATE;
1345: END IF;
1346: /* BUG 11867431 end */
1347: UPDATE ap_invoices_all
1348: SET exchange_rate_type = l_default_exchange_rate_type,
1349: exchange_rate = l_exchange_rate,
1350: exchange_date = l_exchange_date
1351: WHERE invoice_id = p_invoice_id;

Line 1356: UPDATE ap_invoices_all

1352:
1353: /* Bug 9768308 begin */
1354: IF (l_default_exchange_rate_type = 'User') THEN
1355:
1356: UPDATE ap_invoices_all
1357: SET base_amount = ap_utilities_pkg.ap_round_currency(
1358: invoice_amount * l_exchange_rate,
1359: l_base_currency_code)
1360: WHERE invoice_id = p_invoice_id ;

Line 1365: UPDATE ap_invoices_all

1361:
1362: ELSE
1363:
1364: -- euro triangulation
1365: UPDATE ap_invoices_all
1366: SET base_amount = gl_currency_api.convert_amount(
1367: l_inv_currency_code,
1368: l_base_currency_code,
1369: l_exchange_date,

Line 1417: l_invoice_id ap_invoices_all.invoice_id%type;

1413: procedure create_distributions(p_invoice_id IN NUMBER) IS
1414: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1415: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1416:
1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;

Line 1418: l_invoice_num ap_invoices_all.invoice_num%type;

1414: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1415: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1416:
1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;

Line 1419: l_org_id ap_invoices_all.org_id%type;

1415: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1416:
1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

Line 1420: l_invoice_amount ap_invoices_all.invoice_amount%type;

1416:
1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;

Line 1421: l_base_amount ap_invoices_all.base_amount%type;

1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;

Line 1422: l_exchange_rate ap_invoices_all.exchange_rate%type;

1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;

Line 1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

1419: l_org_id ap_invoices_all.org_id%type;
1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;

Line 1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;

1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;

Line 1427: l_exchange_date ap_invoices_all.exchange_date%type;

1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;

Line 1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;

Line 1429: l_vendor_id ap_invoices_all.vendor_id%type;

1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;

Line 1430: l_invoice_date ap_invoices_all.invoice_date%type;

1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;

Line 1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;

1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1435: l_error_code VARCHAR2(4000);

Line 1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;

1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1435: l_error_code VARCHAR2(4000);
1436: l_curr_calling_sequence VARCHAR2(2000);

Line 1457: FROM ap_invoices_all AI,

1453: nvl(AI.disc_is_inv_less_tax_flag,'N'),
1454: nvl(AI.exclude_freight_from_discount,'N'),
1455: pvs.tolerance_id,
1456: pvs.services_tolerance_id
1457: FROM ap_invoices_all AI,
1458: ap_suppliers PV,
1459: ap_supplier_sites_all PVS
1460: WHERE AI.invoice_id = p_invoice_id
1461: AND AI.vendor_id = PV.vendor_id

Line 1468: FROM ap_system_parameters_all asp, ap_invoices_all ai

1464: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1465:
1466: SELECT base_currency_code
1467: INTO l_base_currency_code
1468: FROM ap_system_parameters_all asp, ap_invoices_all ai
1469: WHERE ai.invoice_id = p_invoice_id
1470: AND asp.org_id = ai.org_id;
1471:
1472: l_debug_info := 'Before OPEN Approve_Invoice_Cur';

Line 1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;

1558: p_invoice_id IN NUMBER,
1559: p_calling_sequence IN VARCHAR2)
1560:
1561: IS
1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

Line 1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

1559: p_calling_sequence IN VARCHAR2)
1560:
1561: IS
1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1567: l_curr_calling_sequence VARCHAR2(2000);

Line 1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

1560:
1561: IS
1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1567: l_curr_calling_sequence VARCHAR2(2000);
1568: l_debug_info VARCHAR2(500);

Line 1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

1561: IS
1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1567: l_curr_calling_sequence VARCHAR2(2000);
1568: l_debug_info VARCHAR2(500);
1569: l_api_name VARCHAR2(50);

Line 1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

1562: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1563: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1564: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1565: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1566: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1567: l_curr_calling_sequence VARCHAR2(2000);
1568: l_debug_info VARCHAR2(500);
1569: l_api_name VARCHAR2(50);
1570: l_hold_count NUMBER;

Line 1574: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1570: l_hold_count NUMBER;
1571: l_line_count NUMBER;
1572: l_line_total NUMBER;
1573: l_Sched_Hold_count NUMBER;
1574: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1571: l_line_count NUMBER;
1572: l_line_total NUMBER;
1573: l_Sched_Hold_count NUMBER;
1574: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;

1573: l_Sched_Hold_count NUMBER;
1574: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1574: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;

1575: l_pay_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;

Line 1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

1576:
1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;
1584:

Line 1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

1577: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;
1584:
1585: l_wfitemkey VARCHAR2(50);

Line 1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;

1578: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;
1584:
1585: l_wfitemkey VARCHAR2(50);
1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;

Line 1583: l_requester_id ap_invoices_all.requester_id%TYPE;

1579: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1580: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1581: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;
1584:
1585: l_wfitemkey VARCHAR2(50);
1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1587: -- Bug 6859035

Line 1590: l_org_id ap_invoices_all.org_id%TYPE;

1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1587: -- Bug 6859035
1588: l_period_name ap_invoice_lines_all.period_name%TYPE;
1589: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1590: l_org_id ap_invoices_all.org_id%TYPE;
1591:
1592: -- Bug 7706967 : Start
1593: l_vendor_name ap_suppliers.vendor_name%TYPE;
1594: l_vendor_id ap_suppliers.vendor_id%TYPE;

Line 1652: FROM ap_invoices_all ai

1648: END IF;
1649:
1650: SELECT ai.invoice_date, org_id
1651: INTO l_invoice_date, l_org_id
1652: FROM ap_invoices_all ai
1653: WHERE ai.invoice_id = p_invoice_id ;
1654:
1655: -- Bug 8405782
1656: AP_UTILITIES_PKG.Get_gl_date_and_period_1(

Line 1662: UPDATE ap_invoices_all

1658: P_Period_Name => l_period_name,
1659: P_GL_Date => l_gl_date,
1660: P_Org_Id => l_org_id) ;
1661:
1662: UPDATE ap_invoices_all
1663: SET gl_date = l_gl_date
1664: WHERE invoice_id = p_invoice_id ;
1665:
1666: -- Bug 8345877 commenting out the below fix as

Line 1672: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai

1668:
1669: -- Bug 7706967 - Start
1670: /*SELECT nvl(aps.vendor_name, hzp.party_name)
1671: INTO l_vendor_name
1672: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai
1673: WHERE ai.invoice_id = p_invoice_id
1674: AND aps.vendor_id = ai.vendor_id
1675: AND hzp.party_id = aps.party_id
1676: AND ROWNUM = 1;

Line 1680: FROM ap_supplier_sites_all apss, ap_invoices_all ai

1676: AND ROWNUM = 1;
1677:
1678: SELECT apss.vendor_site_code, ai.vendor_id, ai.vendor_site_id
1679: INTO l_vendor_site_code, l_vendor_id, l_vendor_site_id
1680: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1681: WHERE ai.invoice_id = p_invoice_id
1682: AND apss.vendor_site_id = ai.vendor_site_id;
1683:
1684: UPDATE ap_invoices_all

Line 1684: UPDATE ap_invoices_all

1680: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1681: WHERE ai.invoice_id = p_invoice_id
1682: AND apss.vendor_site_id = ai.vendor_site_id;
1683:
1684: UPDATE ap_invoices_all
1685: SET remit_to_supplier_id = l_vendor_id,
1686: remit_to_supplier_name = l_vendor_name,
1687: remit_to_supplier_site_id = l_vendor_site_id,
1688: remit_to_supplier_site = l_vendor_site_code,

Line 1697: ap_invoices_all ai

1693: -- Bug 9531531 Begin
1694: SELECT po.type_1099
1695: INTO l_type_1099
1696: FROM ap_suppliers po,
1697: ap_invoices_all ai
1698: WHERE po.vendor_id = ai.vendor_id
1699: AND ai.invoice_id = p_invoice_id;
1700:
1701: l_debug_info := 'Derived type_1099 from Supplier: ' || l_type_1099;

Line 1771: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)

1767: SELECT decode(assa.exclude_freight_from_discount,NULL,nvl(aps.exclude_freight_from_discount,'N'),assa.exclude_freight_from_discount)
1768: INTO l_exclude_freight_from_disc
1769: FROM ap_suppliers aps,
1770: ap_supplier_sites_all assa
1771: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1772: AND assa.vendor_id = aps.vendor_id
1773: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1774:
1775: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')

Line 1773: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);

1769: FROM ap_suppliers aps,
1770: ap_supplier_sites_all assa
1771: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1772: AND assa.vendor_id = aps.vendor_id
1773: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1774:
1775: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1776: INTO l_exclude_tax_from_disc
1777: FROM ap_system_parameters asp

Line 1778: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);

1774:
1775: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1776: INTO l_exclude_tax_from_disc
1777: FROM ap_system_parameters asp
1778: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);
1779:
1780: EXCEPTION
1781: WHEN OTHERS THEN NULL;
1782: END;

Line 1788: update ap_invoices_all ai

1784:
1785: -- don't do anything if lines don't exist
1786: /*Bug 14386893*/
1787: if (l_lines_cnt > 0) then
1788: update ap_invoices_all ai
1789: set invoice_amount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1790: amount_applicable_to_discount = l_item_sum + l_misc_sum + l_retained_sum
1791: /* Bug 9239655: Added conditions for adding Freight and Tax lines sum to
1792: amount_applicable_to_discount */

Line 1832: FROM ap_invoices_all ai,

1828: l_default_exchange_Rate_type,
1829: l_exchange_rate,
1830: l_exchange_date,
1831: l_requester_id
1832: FROM ap_invoices_all ai,
1833: ap_system_parameters_all asp
1834: WHERE ai.org_id = asp.org_id
1835: and ai.invoice_id = p_invoice_id;
1836:

Line 1851: UPDATE ap_invoices_all

1847: fnd_msg_pub.add;
1848: RAISE NULL_EXCHG_RATE;
1849: END IF;
1850: /* BUG 11867431 end */
1851: UPDATE ap_invoices_all
1852: SET exchange_rate_type = l_default_exchange_rate_type,
1853: exchange_rate = l_exchange_rate,
1854: exchange_date = l_exchange_date
1855: WHERE invoice_id = p_invoice_id;

Line 1860: UPDATE ap_invoices_all

1856:
1857: /* Bug 9768308 begin */
1858: IF (l_default_exchange_rate_type = 'User') THEN
1859:
1860: UPDATE ap_invoices_all
1861: SET base_amount = ap_utilities_pkg.ap_round_currency(
1862: invoice_amount * l_exchange_rate,
1863: l_base_currency_code)
1864: WHERE invoice_id = p_invoice_id ;

Line 1869: UPDATE ap_invoices_all

1865:
1866: ELSE
1867:
1868: -- euro triangulation
1869: UPDATE ap_invoices_all
1870: SET base_amount = gl_currency_api.convert_amount(
1871: l_inv_currency_code,
1872: l_base_currency_code,
1873: l_exchange_date,

Line 1897: ap_invoices_all i

1893:
1894: SELECT nvl(payment_priority,99)
1895: INTO l_payment_priority
1896: FROM ap_supplier_sites_all s,
1897: ap_invoices_all i
1898: WHERE s.vendor_id = i.vendor_id
1899: AND s.vendor_site_id = i.vendor_site_id
1900: AND i.invoice_id = p_invoice_id ;
1901:

Line 1932: ap_invoices_all ai

1928: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1929: SELECT asu.distribution_set_id
1930: INTO l_dist_set_id
1931: FROM ap_supplier_sites_all asu,
1932: ap_invoices_all ai
1933: WHERE ai.vendor_site_id = asu.vendor_site_id
1934: AND ai.invoice_id = p_invoice_id;
1935: --Create Distributions
1936: IF l_dist_set_id is NOT NULL THEN

Line 1945: FROM ap_invoices_all

1941: BEGIN
1942:
1943: SELECT nvl(approval_iteration, 0)
1944: INTO l_iter
1945: FROM ap_invoices_all
1946: WHERE invoice_id = p_invoice_id;
1947:
1948: EXCEPTION
1949: WHEN OTHERS THEN

Line 3112: l_approval_iteration AP_INVOICES_ALL.approval_iteration%TYPE;

3108: PROCEDURE stop_approval(p_invoice_id NUMBER) IS
3109:
3110: dummy BOOLEAN;
3111: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3112: l_approval_iteration AP_INVOICES_ALL.approval_iteration%TYPE;
3113:
3114: BEGIN
3115:
3116: BEGIN

Line 3120: FROM ap_invoices_all ai

3116: BEGIN
3117:
3118: SELECT nvl(approval_iteration, 1)
3119: INTO l_approval_iteration
3120: FROM ap_invoices_all ai
3121: WHERE invoice_id = p_invoice_id;
3122:
3123: SELECT history_type,
3124: invoice_id,

Line 3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,

3207: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
3208: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
3209: p_billable_flag IN pa_tasks.billable_flag%TYPE,
3210: p_chart_of_accounts_id IN NUMBER,
3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,

Line 3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,

3208: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
3209: p_billable_flag IN pa_tasks.billable_flag%TYPE,
3210: p_chart_of_accounts_id IN NUMBER,
3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,

Line 3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,

3209: p_billable_flag IN pa_tasks.billable_flag%TYPE,
3210: p_chart_of_accounts_id IN NUMBER,
3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,

Line 3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,

3210: p_chart_of_accounts_id IN NUMBER,
3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,

Line 3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,

3211: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,

Line 3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,

3212: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,

Line 3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,

3213: p_attribute2 IN ap_invoices_all.attribute2%TYPE,
3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,

Line 3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,

3214: p_attribute3 IN ap_invoices_all.attribute3%TYPE,
3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,

Line 3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,

3215: p_attribute4 IN ap_invoices_all.attribute4%TYPE,
3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,

Line 3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,

3216: p_attribute5 IN ap_invoices_all.attribute5%TYPE,
3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,

Line 3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,

3217: p_attribute6 IN ap_invoices_all.attribute6%TYPE,
3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,

Line 3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,

3218: p_attribute7 IN ap_invoices_all.attribute7%TYPE,
3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,

Line 3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,

3219: p_attribute8 IN ap_invoices_all.attribute8%TYPE,
3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,

Line 3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,

3220: p_attribute9 IN ap_invoices_all.attribute9%TYPE,
3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,

Line 3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,

3221: p_attribute10 IN ap_invoices_all.attribute10%TYPE,
3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,

Line 3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,

3222: p_attribute11 IN ap_invoices_all.attribute11%TYPE,
3223: p_attribute12 IN ap_invoices_all.attribute12%TYPE,
3224: p_attribute13 IN ap_invoices_all.attribute13%TYPE,
3225: p_attribute14 IN ap_invoices_all.attribute14%TYPE,
3226: p_attribute15 IN ap_invoices_all.attribute15%TYPE,
3227: p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
3228: p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
3229: p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
3230: p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,