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 237: l_po_header_id ap_invoices_all.po_header_id%TYPE;

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

Line 238: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;

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

Line 239: l_org_id ap_invoices_all.org_id%TYPE;

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

Line 240: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

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

Line 241: l_invoice_date ap_invoices_all.invoice_date%TYPE;

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

Line 242: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;

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

Line 243: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;

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

Line 275: from ap_invoices_all

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

Line 583: from ap_invoices_all

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

Line 850: ap_invoices_all AI,

846: l_invoice_date,
847: l_invoice_description,
848: l_supplier_role
849: FROM
850: ap_invoices_all AI,
851: po_vendors PV,
852: po_vendor_sites_all PVS,
853: fnd_user u
854: WHERE

Line 1044: update ap_invoices_all

1040: p_terms_id => l_terms_id,
1041: p_terms_date => l_terms_date,
1042: p_calling_sequence => l_curr_calling_sequence);
1043:
1044: update ap_invoices_all
1045: set terms_id = l_terms_id,
1046: terms_date = l_terms_date
1047: where invoice_id = p_invoice_id;
1048:

Line 1123: update ap_invoices_all

1119: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1121: END IF;
1122:
1123: update ap_invoices_all
1124: set doc_category_code = l_doc_category_code,
1125: doc_sequence_value = l_db_sequence_value,
1126: doc_sequence_id = l_db_sequence_id
1127: where invoice_id = p_invoice_id;

Line 1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;

1155: p_sequence_numbering IN VARCHAR2,
1156: p_calling_sequence IN VARCHAR2)
1157:
1158: IS
1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

Line 1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

1156: p_calling_sequence IN VARCHAR2)
1157:
1158: IS
1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1164: l_curr_calling_sequence VARCHAR2(2000);

Line 1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

1157:
1158: IS
1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1164: l_curr_calling_sequence VARCHAR2(2000);
1165: l_debug_info VARCHAR2(500);

Line 1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

1158: IS
1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1164: l_curr_calling_sequence VARCHAR2(2000);
1165: l_debug_info VARCHAR2(500);
1166: l_api_name VARCHAR2(50);

Line 1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

1159: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1160: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1161: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1162: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1163: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1164: l_curr_calling_sequence VARCHAR2(2000);
1165: l_debug_info VARCHAR2(500);
1166: l_api_name VARCHAR2(50);
1167: l_hold_count NUMBER;

Line 1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1167: l_hold_count NUMBER;
1168: l_line_count NUMBER;
1169: l_line_total NUMBER;
1170: l_Sched_Hold_count NUMBER;
1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

Line 1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;

1168: l_line_count NUMBER;
1169: l_line_total NUMBER;
1170: l_Sched_Hold_count NUMBER;
1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1169: l_line_total NUMBER;
1170: l_Sched_Hold_count NUMBER;
1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1177: l_requester_id ap_invoices_all.requester_id%TYPE;

Line 1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;

1170: l_Sched_Hold_count NUMBER;
1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1177: l_requester_id ap_invoices_all.requester_id%TYPE;
1178:

Line 1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

1171: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1177: l_requester_id ap_invoices_all.requester_id%TYPE;
1178:
1179: BEGIN

Line 1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;

1172: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1177: l_requester_id ap_invoices_all.requester_id%TYPE;
1178:
1179: BEGIN
1180: -- Update the calling sequence

Line 1177: l_requester_id ap_invoices_all.requester_id%TYPE;

1173: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1174: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1175: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1176: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1177: l_requester_id ap_invoices_all.requester_id%TYPE;
1178:
1179: BEGIN
1180: -- Update the calling sequence
1181:

Line 1217: update ap_invoices_all

1213: END;
1214:
1215: -- don't do anything if lines don't exist
1216: if ( l_item_sum <> 0 ) then
1217: update ap_invoices_all
1218: set invoice_amount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1219: amount_applicable_to_discount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1220: net_of_retainage_flag = DECODE(l_retained_sum, 0, 'N', 'Y')
1221: where invoice_id = p_invoice_id;

Line 1282: FROM ap_invoices_all ai,

1278: l_default_exchange_Rate_type,
1279: l_exchange_rate,
1280: l_exchange_date,
1281: l_requester_id
1282: FROM ap_invoices_all ai,
1283: ap_system_parameters_all asp
1284: WHERE ai.org_id = asp.org_id
1285: and ai.invoice_id = p_invoice_id;
1286:

Line 1289: UPDATE ap_invoices_all

1285: and ai.invoice_id = p_invoice_id;
1286:
1287: IF l_base_currency_code <> l_inv_currency_code THEN
1288:
1289: UPDATE ap_invoices_all
1290: SET exchange_rate_type = l_default_exchange_rate_type,
1291: exchange_rate = l_exchange_rate,
1292: exchange_date = l_exchange_date
1293: WHERE invoice_id = p_invoice_id;

Line 1329: l_invoice_id ap_invoices_all.invoice_id%type;

1325: procedure create_distributions(p_invoice_id IN NUMBER) IS
1326: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1327: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1328:
1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;

Line 1330: l_invoice_num ap_invoices_all.invoice_num%type;

1326: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1327: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1328:
1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;

Line 1331: l_org_id ap_invoices_all.org_id%type;

1327: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1328:
1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

Line 1332: l_invoice_amount ap_invoices_all.invoice_amount%type;

1328:
1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;

Line 1333: l_base_amount ap_invoices_all.base_amount%type;

1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;

Line 1334: l_exchange_rate ap_invoices_all.exchange_rate%type;

1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;

Line 1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

1331: l_org_id ap_invoices_all.org_id%type;
1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;

Line 1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;

1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;

Line 1339: l_exchange_date ap_invoices_all.exchange_date%type;

1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;

Line 1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;

Line 1341: l_vendor_id ap_invoices_all.vendor_id%type;

1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;

Line 1342: l_invoice_date ap_invoices_all.invoice_date%type;

1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;

Line 1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;

1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1347: l_error_code VARCHAR2(4000);

Line 1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;

1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1347: l_error_code VARCHAR2(4000);
1348: l_curr_calling_sequence VARCHAR2(2000);

Line 1369: FROM ap_invoices_all AI,

1365: nvl(AI.disc_is_inv_less_tax_flag,'N'),
1366: nvl(AI.exclude_freight_from_discount,'N'),
1367: pvs.tolerance_id,
1368: pvs.services_tolerance_id
1369: FROM ap_invoices_all AI,
1370: ap_suppliers PV,
1371: ap_supplier_sites_all PVS
1372: WHERE AI.invoice_id = p_invoice_id
1373: AND AI.vendor_id = PV.vendor_id

Line 1380: FROM ap_system_parameters_all asp, ap_invoices_all ai

1376: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1377:
1378: SELECT base_currency_code
1379: INTO l_base_currency_code
1380: FROM ap_system_parameters_all asp, ap_invoices_all ai
1381: WHERE ai.invoice_id = p_invoice_id
1382: AND asp.org_id = ai.org_id;
1383:
1384: l_debug_info := 'Before OPEN Approve_Invoice_Cur';

Line 1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;

1470: p_invoice_id IN NUMBER,
1471: p_calling_sequence IN VARCHAR2)
1472:
1473: IS
1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

Line 1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;

1471: p_calling_sequence IN VARCHAR2)
1472:
1473: IS
1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1479: l_curr_calling_sequence VARCHAR2(2000);

Line 1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;

1472:
1473: IS
1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1479: l_curr_calling_sequence VARCHAR2(2000);
1480: l_debug_info VARCHAR2(500);

Line 1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;

1473: IS
1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1479: l_curr_calling_sequence VARCHAR2(2000);
1480: l_debug_info VARCHAR2(500);
1481: l_api_name VARCHAR2(50);

Line 1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;

1474: l_item_sum ap_invoices_all.invoice_amount%TYPE;
1475: l_tax_sum ap_invoices_all.invoice_amount%TYPE;
1476: l_misc_sum ap_invoices_all.invoice_amount%TYPE;
1477: l_frt_sum ap_invoices_all.invoice_amount%TYPE;
1478: l_retained_sum ap_invoices_all.invoice_amount%TYPE;
1479: l_curr_calling_sequence VARCHAR2(2000);
1480: l_debug_info VARCHAR2(500);
1481: l_api_name VARCHAR2(50);
1482: l_hold_count NUMBER;

Line 1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1482: l_hold_count NUMBER;
1483: l_line_count NUMBER;
1484: l_line_total NUMBER;
1485: l_Sched_Hold_count NUMBER;
1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

Line 1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;

1483: l_line_count NUMBER;
1484: l_line_total NUMBER;
1485: l_Sched_Hold_count NUMBER;
1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;

1484: l_line_total NUMBER;
1485: l_Sched_Hold_count NUMBER;
1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;

Line 1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;

1485: l_Sched_Hold_count NUMBER;
1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;
1493:

Line 1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

1486: l_inv_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;
1493:
1494: l_wfitemkey VARCHAR2(50);

Line 1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;

1487: l_invoice_date ap_invoices_all.invoice_date%TYPE;
1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;
1493:
1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;

Line 1492: l_requester_id ap_invoices_all.requester_id%TYPE;

1488: l_base_currency_code ap_invoices_all.invoice_currency_code%TYPE;
1489: l_default_exchange_Rate_type ap_invoices_all.exchange_rate_type%TYPE;
1490: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;
1493:
1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035

Line 1499: l_org_id ap_invoices_all.org_id%TYPE;

1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;
1500:
1501: -- Bug 7706967 : Start
1502: l_vendor_name ap_suppliers.vendor_name%TYPE;
1503: l_vendor_id ap_suppliers.vendor_id%TYPE;

Line 1543: FROM ap_invoices_all ai

1539: END IF;
1540:
1541: SELECT ai.invoice_date, org_id
1542: INTO l_invoice_date, l_org_id
1543: FROM ap_invoices_all ai
1544: WHERE ai.invoice_id = p_invoice_id ;
1545:
1546: AP_INVOICES_PKG.Get_gl_date_and_period(
1547: P_Date => l_invoice_date,

Line 1552: UPDATE ap_invoices_all

1548: P_Period_Name => l_period_name,
1549: P_GL_Date => l_gl_date,
1550: P_Org_Id => l_org_id) ;
1551:
1552: UPDATE ap_invoices_all
1553: SET gl_date = l_gl_date
1554: WHERE invoice_id = p_invoice_id ;
1555:
1556: -- Bug 7706967 - Start

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

1555:
1556: -- Bug 7706967 - Start
1557: SELECT nvl(aps.vendor_name, hzp.party_name)
1558: INTO l_vendor_name
1559: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai
1560: WHERE ai.invoice_id = p_invoice_id
1561: AND aps.vendor_id = ai.vendor_id
1562: AND hzp.party_id = aps.party_id
1563: AND ROWNUM = 1;

Line 1567: FROM ap_supplier_sites_all apss, ap_invoices_all ai

1563: AND ROWNUM = 1;
1564:
1565: SELECT apss.vendor_site_code, ai.vendor_id, ai.vendor_site_id
1566: INTO l_vendor_site_code, l_vendor_id, l_vendor_site_id
1567: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1568: WHERE ai.invoice_id = p_invoice_id
1569: AND apss.vendor_site_id = ai.vendor_site_id;
1570:
1571: UPDATE ap_invoices_all

Line 1571: UPDATE ap_invoices_all

1567: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1568: WHERE ai.invoice_id = p_invoice_id
1569: AND apss.vendor_site_id = ai.vendor_site_id;
1570:
1571: UPDATE ap_invoices_all
1572: SET remit_to_supplier_id = l_vendor_id,
1573: remit_to_supplier_name = l_vendor_name,
1574: remit_to_supplier_site_id = l_vendor_site_id,
1575: remit_to_supplier_site = l_vendor_site_code,

Line 1620: update ap_invoices_all

1616: END;
1617:
1618: -- don't do anything if lines don't exist
1619: if ( l_item_sum <> 0 ) then
1620: update ap_invoices_all
1621: set invoice_amount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1622: amount_applicable_to_discount = l_item_sum + l_tax_sum + l_misc_sum + l_frt_sum + l_retained_sum,
1623: net_of_retainage_flag = DECODE(l_retained_sum, 0, 'N', 'Y'),
1624: APPROVAL_ITERATION = 1 --Needed for workflow process.

Line 1653: ap_invoices_all ai

1649: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1650: SELECT asu.distribution_set_id
1651: INTO l_dist_set_id
1652: FROM ap_supplier_sites_all asu,
1653: ap_invoices_all ai
1654: WHERE ai.vendor_site_id = asu.vendor_site_id
1655: AND ai.invoice_id = p_invoice_id;
1656: --Create Distributions
1657: IF l_dist_set_id is NOT NULL THEN