eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICES

Line 495: ap_invoices AI

491: SELECT NVL(sla_ledger_cash_basis_flag, 'N')
492: INTO l_cash_basis
493: FROM ap_system_parameters ASP,
494: gl_sets_of_books SOB,
495: ap_invoices AI
496: WHERE AI.invoice_id = x_invoice_id
497: AND AI.org_id = ASP.org_id
498: AND asp.set_of_books_id = sob.set_of_books_id;
499:

Line 805: from ap_invoices

801: -------------------------------------------------------------------------
802: --bug 9169915
803: select org_id,set_of_books_id --added set_of_books_id for bug#10241241
804: into l_org_id,l_set_of_books_id
805: from ap_invoices
806: where invoice_id = X_invoice_id;
807:
808: SELECT JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id, null)
809: INTO l_country_code

Line 1243: ap_invoices.exchange_rate%TYPE;

1239: l_dist_total number;
1240: l_base_currency_code
1241: ap_system_parameters.base_currency_code%TYPE;
1242: l_exchange_rate
1243: ap_invoices.exchange_rate%TYPE;
1244: l_exchange_rate_type
1245: ap_invoices.exchange_rate_type%TYPE;
1246: l_exchange_date
1247: ap_invoices.exchange_date%TYPE;

Line 1245: ap_invoices.exchange_rate_type%TYPE;

1241: ap_system_parameters.base_currency_code%TYPE;
1242: l_exchange_rate
1243: ap_invoices.exchange_rate%TYPE;
1244: l_exchange_rate_type
1245: ap_invoices.exchange_rate_type%TYPE;
1246: l_exchange_date
1247: ap_invoices.exchange_date%TYPE;
1248: l_base_amount
1249: ap_invoices.base_amount%TYPE;

Line 1247: ap_invoices.exchange_date%TYPE;

1243: ap_invoices.exchange_rate%TYPE;
1244: l_exchange_rate_type
1245: ap_invoices.exchange_rate_type%TYPE;
1246: l_exchange_date
1247: ap_invoices.exchange_date%TYPE;
1248: l_base_amount
1249: ap_invoices.base_amount%TYPE;
1250: l_invoice_amount
1251: ap_invoices.invoice_amount%TYPE;

Line 1249: ap_invoices.base_amount%TYPE;

1245: ap_invoices.exchange_rate_type%TYPE;
1246: l_exchange_date
1247: ap_invoices.exchange_date%TYPE;
1248: l_base_amount
1249: ap_invoices.base_amount%TYPE;
1250: l_invoice_amount
1251: ap_invoices.invoice_amount%TYPE;
1252: l_invoice_currency_code
1253: ap_invoices.invoice_currency_code%TYPE;

Line 1251: ap_invoices.invoice_amount%TYPE;

1247: ap_invoices.exchange_date%TYPE;
1248: l_base_amount
1249: ap_invoices.base_amount%TYPE;
1250: l_invoice_amount
1251: ap_invoices.invoice_amount%TYPE;
1252: l_invoice_currency_code
1253: ap_invoices.invoice_currency_code%TYPE;
1254: l_last_update_login
1255: ap_invoices.last_update_login%TYPE;

Line 1253: ap_invoices.invoice_currency_code%TYPE;

1249: ap_invoices.base_amount%TYPE;
1250: l_invoice_amount
1251: ap_invoices.invoice_amount%TYPE;
1252: l_invoice_currency_code
1253: ap_invoices.invoice_currency_code%TYPE;
1254: l_last_update_login
1255: ap_invoices.last_update_login%TYPE;
1256: l_last_updated_by
1257: ap_invoices.last_updated_by%TYPE;

Line 1255: ap_invoices.last_update_login%TYPE;

1251: ap_invoices.invoice_amount%TYPE;
1252: l_invoice_currency_code
1253: ap_invoices.invoice_currency_code%TYPE;
1254: l_last_update_login
1255: ap_invoices.last_update_login%TYPE;
1256: l_last_updated_by
1257: ap_invoices.last_updated_by%TYPE;
1258: l_last_update_date
1259: ap_invoices.last_update_date%TYPE;

Line 1257: ap_invoices.last_updated_by%TYPE;

1253: ap_invoices.invoice_currency_code%TYPE;
1254: l_last_update_login
1255: ap_invoices.last_update_login%TYPE;
1256: l_last_updated_by
1257: ap_invoices.last_updated_by%TYPE;
1258: l_last_update_date
1259: ap_invoices.last_update_date%TYPE;
1260: l_invoice_distribution_id
1261: ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 1259: ap_invoices.last_update_date%TYPE;

1255: ap_invoices.last_update_login%TYPE;
1256: l_last_updated_by
1257: ap_invoices.last_updated_by%TYPE;
1258: l_last_update_date
1259: ap_invoices.last_update_date%TYPE;
1260: l_invoice_distribution_id
1261: ap_invoice_distributions.invoice_distribution_id%TYPE;
1262: l_project_id
1263: ap_invoice_distributions.project_id%TYPE;

Line 1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;

1312: l_dist_attribute14 ap_invoice_distributions.attribute1%TYPE;
1313: l_dist_attribute15 ap_invoice_distributions.attribute1%TYPE;
1314: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1315: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;

Line 1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;

1313: l_dist_attribute15 ap_invoice_distributions.attribute1%TYPE;
1314: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1315: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;

Line 1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;

1314: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1315: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;

Line 1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;

1315: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;

Line 1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;

1316: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;

Line 1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;

1317: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;

Line 1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;

1318: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;

Line 1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;

1319: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;

Line 1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;

1320: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;

Line 1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;

1321: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;

Line 1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;

1322: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;

Line 1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;

1323: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;

Line 1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;

1324: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1332: l_msg_application VARCHAR2(25);

Line 1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;

1325: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1332: l_msg_application VARCHAR2(25);
1333: l_msg_type VARCHAR2(25);

Line 1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;

1326: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1332: l_msg_application VARCHAR2(25);
1333: l_msg_type VARCHAR2(25);
1334: l_msg_token1 VARCHAR2(30);

Line 1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;

1327: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1328: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1329: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1330: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1331: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1332: l_msg_application VARCHAR2(25);
1333: l_msg_type VARCHAR2(25);
1334: l_msg_token1 VARCHAR2(30);
1335: l_msg_token2 VARCHAR2(30);

Line 1341: ap_invoices.invoice_type_lookup_code%TYPE;

1337: l_msg_count NUMBER;
1338: l_msg_data VARCHAR2(200); /*bug12612482 changed from 30 to 200*/
1339: l_billable_flag VARCHAR2(25);
1340: l_invoice_type_lookup_code
1341: ap_invoices.invoice_type_lookup_code%TYPE;
1342: l_chart_of_accounts_id NUMBER;
1343: l_DIST_CODE_COMBINATION_ID NUMBER;
1344: l_concat_ids Varchar2(2000);
1345: l_concat_segs Varchar2(2000);

Line 1360: l_org_id ap_invoices_all.org_id%type;

1356: l_round_amt_exists BOOLEAN := FALSE;
1357: l_rounded_amt NUMBER;
1358: --Bug 4539462 DBI logging
1359: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1360: l_org_id ap_invoices_all.org_id%type;
1361:
1362: l_base_amt NUMBER; --6892789
1363: l_modified_dist_rounding_amt NUMBER; --6892789
1364: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

Line 1384: FROM ap_invoices AI,

1380: AI.last_update_date,
1381: AIL.last_update_date ),
1382: AIL.line_number,
1383: AI.org_id
1384: FROM ap_invoices AI,
1385: ap_invoice_lines AIL
1386: WHERE AI.invoice_id = X_invoice_id
1387: AND AIL.invoice_id = AI.invoice_id
1388: AND AIL.line_number = NVL(X_line_number, AIL.line_number);

Line 1444: ap_invoices AI,

1440: AI.attribute14,
1441: AI.attribute15,
1442: gsob.chart_of_accounts_id
1443: FROM ap_invoice_distributions AID,
1444: ap_invoices AI,
1445: ap_suppliers PV,
1446: po_distributions PD,
1447: ap_system_parameters ap,
1448: gl_sets_of_books gsob

Line 1492: debug_info := 'select AP_INVOICES info';

1488: -- l_base_currency_code
1489: --FROM financials_system_parameters FSP,
1490: -- ap_system_parameters SP;
1491:
1492: debug_info := 'select AP_INVOICES info';
1493:
1494: /*-----------------------------------------------------------------+
1495: | Fetch the invoice information that we need in order to update |
1496: | the distribution base amounts |

Line 3746: FROM ap_invoices i, ap_invoice_distributions d2, fnd_currencies F

3742: ROUND((SUM(d2.amount) * i.exchange_rate)
3743: /MAX(f.minimum_accountable_unit))*
3744: MAX(f.minimum_accountable_unit))),
3745: d1.base_amount)
3746: FROM ap_invoices i, ap_invoice_distributions d2, fnd_currencies F
3747: WHERE d1.invoice_id = i.invoice_id
3748: AND d1.invoice_id = d2.invoice_id
3749: AND f.currency_code = X_Base_Currency_Code
3750: GROUP BY i.exchange_rate)

Line 3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3754: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3755: FROM ap_invoice_distributions_all d5
3756: WHERE (d5.invoice_id, abs(d5.amount)) IN
3757: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3758: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3759: WHERE i1.invoice_id = X_Invoice_Id
3760: AND i1.invoice_id = d3.invoice_id
3761: AND d3.line_type_lookup_code NOT IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV','IPV', 'ERV') -- Bug 11654030 <> 'TAX', Bug 12691958: Added excluding 'IPV' and 'ERV' lines
3762: AND d3.related_id IS NULL -- Bug 13864403

Line 3797: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,

3793: -- ap_invoice_distributions given a line number number and/or line record.
3794: -- It returns FALSE if an error is encountered.
3795: -----------------------------------------------------------------------
3796: FUNCTION Insert_Single_Dist_From_Line(
3797: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3798: X_invoice_id IN NUMBER,
3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

Line 3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

3795: -----------------------------------------------------------------------
3796: FUNCTION Insert_Single_Dist_From_Line(
3797: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3798: X_invoice_id IN NUMBER,
3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

Line 3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,

3796: FUNCTION Insert_Single_Dist_From_Line(
3797: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3798: X_invoice_id IN NUMBER,
3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

Line 3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

3797: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3798: X_invoice_id IN NUMBER,
3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3805: X_line_number IN NUMBER,

Line 3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

3798: X_invoice_id IN NUMBER,
3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3805: X_line_number IN NUMBER,
3806: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

Line 3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

3799: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3805: X_line_number IN NUMBER,
3806: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3807: X_line_source IN VARCHAR2,

Line 3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

3800: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3801: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3805: X_line_number IN NUMBER,
3806: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3807: X_line_source IN VARCHAR2,
3808: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',

Line 3806: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

3802: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3803: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3804: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3805: X_line_number IN NUMBER,
3806: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3807: X_line_source IN VARCHAR2,
3808: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',
3809: X_Validate_Info IN BOOLEAN DEFAULT TRUE,
3810: X_Error_Code OUT NOCOPY VARCHAR2,

Line 3962: --of ap_invoices_pkg.r_invoice_line_rec

3958: GLOBAL_ATTRIBUTE18,
3959: GLOBAL_ATTRIBUTE19,
3960: GLOBAL_ATTRIBUTE20,
3961: --ETAX: Invwkb, added included_tax_amount as modified the def
3962: --of ap_invoices_pkg.r_invoice_line_rec
3963: INCLUDED_TAX_AMOUNT,
3964: PRIMARY_INTENDED_USE,
3965: APPLICATION_ID,
3966: PRODUCT_TABLE,

Line 3981: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

3977: WHERE invoice_id = X_invoice_id
3978: AND line_number = X_line_number;
3979:
3980:
3981: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
3982: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec; --bug 8713737
3983:
3984: l_distribution_class
3985: AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;

Line 4018: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4014: debug_context VARCHAR2(2000);
4015: l_dist_code_concat VARCHAR2(2000);
4016: l_invoice_distribution_id
4017: ap_invoice_distributions.invoice_distribution_id%TYPE;
4018: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4019: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
4020: l_web_parameter_id number; --Bug5003249
4021: l_employee_ccid number;
4022: l_message_text fnd_new_messages.message_text%type;

Line 4132: from ap_invoices

4128: l_invoice_attribute_rec.attribute12,
4129: l_invoice_attribute_rec.attribute13,
4130: l_invoice_attribute_rec.attribute14,
4131: l_invoice_attribute_rec.attribute15
4132: from ap_invoices
4133: where invoice_id = l_invoice_line_rec.invoice_id;
4134: EXCEPTION
4135: WHEN NO_DATA_FOUND THEN
4136: debug_info := debug_info ||': Failed to fetch Invoice header DFF info.';

Line 4266: AP_INVOICES_PKG.get_expenditure_item_date(

4262: debug_info := 'Get expenditure item date and validate if PA related';
4263: IF (l_invoice_line_rec.project_id is not null) then
4264: IF (l_invoice_line_rec.expenditure_item_date is null) then
4265: l_invoice_line_rec.expenditure_item_date :=
4266: AP_INVOICES_PKG.get_expenditure_item_date(
4267: l_invoice_line_rec.invoice_id,
4268: X_invoice_date,
4269: l_open_GL_date,
4270: NULL,

Line 4332: FROM ap_invoices_all

4328: /* Bug 5102724 */
4329: BEGIN
4330: SELECT invoice_type_lookup_code
4331: INTO l_invoice_type_lookup_code
4332: FROM ap_invoices_all
4333: WHERE invoice_id = X_invoice_id;
4334: EXCEPTION
4335: WHEN no_data_found then
4336: NULL;

Line 5050: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,

5046: -- It returns FALSE if an error is encountered.
5047: -----------------------------------------------------------------------
5048:
5049: FUNCTION Insert_AWT_Dist_From_Line(
5050: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
5051: X_invoice_id IN NUMBER,
5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

Line 5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

5048:
5049: FUNCTION Insert_AWT_Dist_From_Line(
5050: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
5051: X_invoice_id IN NUMBER,
5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

Line 5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,

5049: FUNCTION Insert_AWT_Dist_From_Line(
5050: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
5051: X_invoice_id IN NUMBER,
5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

Line 5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

5050: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
5051: X_invoice_id IN NUMBER,
5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
5058: X_line_number IN NUMBER,

Line 5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

5051: X_invoice_id IN NUMBER,
5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
5058: X_line_number IN NUMBER,
5059: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

Line 5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

5052: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
5058: X_line_number IN NUMBER,
5059: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
5060: X_line_source IN VARCHAR2,

Line 5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

5053: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
5054: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
5058: X_line_number IN NUMBER,
5059: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
5060: X_line_source IN VARCHAR2,
5061: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',

Line 5059: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

5055: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
5056: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
5057: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
5058: X_line_number IN NUMBER,
5059: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
5060: X_line_source IN VARCHAR2,
5061: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',
5062: X_Validate_Info IN BOOLEAN DEFAULT TRUE,
5063: X_Error_Code OUT NOCOPY VARCHAR2,

Line 5230: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

5226: WHERE invoice_id = X_invoice_id
5227: AND line_number = X_line_number;
5228:
5229:
5230: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
5231:
5232: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5233: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
5234: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

Line 5261: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

5257: debug_info VARCHAR2(2000); --Bug 8725625-Increased width
5258: debug_context VARCHAR2(2000);
5259: l_dist_code_concat VARCHAR2(2000);
5260: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5261: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
5262: l_sys_link_function VARCHAR2(2);
5263: l_web_parameter_id number;
5264: l_employee_ccid number;
5265: l_message_text fnd_new_messages.message_text%type;

Line 6023: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

6019: --------------------------------------------------------------------------
6020:
6021: FUNCTION Get_Proj_And_Acc_For_Chrg_Dist(
6022: X_invoice_id IN NUMBER,
6023: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
6024: X_vendor_id IN NUMBER,
6025: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
6026: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
6027: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

Line 6025: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

6021: FUNCTION Get_Proj_And_Acc_For_Chrg_Dist(
6022: X_invoice_id IN NUMBER,
6023: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
6024: X_vendor_id IN NUMBER,
6025: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
6026: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
6027: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
6028: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
6029: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,

Line 6031: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

6027: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
6028: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
6029: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
6030: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
6031: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
6032: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
6033: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
6034: X_line_number IN NUMBER,
6035: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,

Line 6032: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

6028: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
6029: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
6030: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
6031: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
6032: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
6033: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
6034: X_line_number IN NUMBER,
6035: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,
6036: X_Period_Name IN AP_INVOICE_LINES.PERIOD_NAME%TYPE,

Line 6033: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

6029: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
6030: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
6031: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
6032: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
6033: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
6034: X_line_number IN NUMBER,
6035: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,
6036: X_Period_Name IN AP_INVOICE_LINES.PERIOD_NAME%TYPE,
6037: X_chrg_line_project_id IN AP_INVOICE_LINES.PROJECT_ID%TYPE,

Line 6099: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

6095: l_billable_flag VARCHAR2(25);
6096: l_unbuilt_flex VARCHAR2(240):='';
6097: l_reason_unbuilt_flex VARCHAR2(2000):='';
6098: l_error_found VARCHAR2(1) := 'N';
6099: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6100: current_calling_sequence VARCHAR2(200);
6101: debug_context VARCHAR2(2000);
6102: debug_info VARCHAR2(100);
6103: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 6103: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

6099: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6100: current_calling_sequence VARCHAR2(200);
6101: debug_context VARCHAR2(2000);
6102: debug_info VARCHAR2(100);
6103: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
6104: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
6105: l_web_parameter_id number; --Bug5003249
6106: l_employee_ccid number;
6107: l_message_text fnd_new_messages.message_text%TYPE;

Line 6142: X_expenditure_item_date := AP_INVOICES_PKG.get_expenditure_item_date(

6138: -------------------------------------------------------------------
6139: IF (X_project_id IS NOT NULL AND X_item_dist_project_id IS NOT NULL) then
6140: user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6141:
6142: X_expenditure_item_date := AP_INVOICES_PKG.get_expenditure_item_date(
6143: X_invoice_id,
6144: X_invoice_date,
6145: X_GL_date,
6146: X_item_po_dist_id,

Line 6260: FROM ap_invoices_all

6256: l_invoice_attribute_rec.attribute12,
6257: l_invoice_attribute_rec.attribute13,
6258: l_invoice_attribute_rec.attribute14,
6259: l_invoice_attribute_rec.attribute15
6260: FROM ap_invoices_all
6261: WHERE invoice_id = X_invoice_id;
6262: EXCEPTION
6263: WHEN no_data_found then
6264: NULL;

Line 6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

6698: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
6699: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

Line 6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

6699: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;

6700: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

6701: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
6709: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;

Line 6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

6702: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
6709: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
6710: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;

Line 6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

6703: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
6709: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
6710: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;
6711: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;

Line 6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

6704: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
6705: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
6706: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
6707: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
6708: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
6709: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
6710: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;
6711: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;
6712: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;

Line 7022: FROM ap_invoices

7018: l_exchange_rate_type,
7019: l_exchange_date,
7020: l_invoice_currency_code,
7021: l_invoice_amount
7022: FROM ap_invoices
7023: WHERE invoice_id = X_invoice_id;
7024:
7025: EXCEPTION
7026: When no_data_found then

Line 7063: ap_invoices_all ai

7059: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
7060: SUM(ail.amount) )
7061: INTO l_sum_lines_amount
7062: FROM ap_invoice_lines_all ail,
7063: ap_invoices_all ai
7064: WHERE ai.invoice_id = ail.invoice_id
7065: AND ail.invoice_id = X_invoice_id
7066: AND ail.line_type_lookup_code NOT IN ('AWT')
7067: /*bugfix:5685469*/

Line 8173: ap_invoices ai

8169:
8170: SELECT nvl(ai.invoice_num,0)
8171: INTO l_inv_num
8172: FROM ap_invoice_distributions aid,
8173: ap_invoices ai
8174: WHERE aid.invoice_distribution_id = X_invoice_dist_id
8175: AND aid.invoice_id = ai.invoice_id;
8176:
8177: RETURN(l_inv_num);

Line 8282: l_inv_currency_code ap_invoices.invoice_currency_code%TYPE;

8278: X_DEBUG_CONTEXT IN OUT NOCOPY VARCHAR2,
8279: X_CALLING_SEQUENCE IN OUT NOCOPY VARCHAR2) Return Boolean
8280:
8281: IS
8282: l_inv_currency_code ap_invoices.invoice_currency_code%TYPE;
8283: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
8284: l_dist_line_type VARCHAR2(25);
8285: l_inv_price ap_invoice_distributions.unit_price%TYPE;
8286: l_qty_invoiced NUMBER;

Line 8291: l_inv_rate ap_invoices.exchange_rate%TYPE;

8287: l_po_qty NUMBER;
8288: l_po_price po_line_locations.price_override%TYPE;
8289: l_po_rate NUMBER;
8290: l_rtxn_rate NUMBER;
8291: l_inv_rate ap_invoices.exchange_rate%TYPE;
8292: l_match_option po_line_locations.match_option%TYPE;
8293: l_rtxn_uom VARCHAR2(25);
8294: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
8295: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

Line 8308: l_corrected_inv_rate ap_invoices.exchange_rate%TYPE;

8304:
8305: l_original_dist_base_amt NUMBER;
8306: l_original_dist_amt NUMBER;
8307:
8308: l_corrected_inv_rate ap_invoices.exchange_rate%TYPE;
8309: current_calling_sequence VARCHAR2(2000);
8310: l_debug_info VARCHAR2(100);
8311:
8312: l_match_basis po_line_types.matching_basis%TYPE; -- Amount Based Matching

Line 8344: FROM ap_invoices_all AI,

8340: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
8341: D.corrected_quantity, -- l_corrected_quantity
8342: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8343: ail.line_source --Bug#10416960
8344: FROM ap_invoices_all AI,
8345: ap_system_parameters_all ASP,
8346: ap_invoice_distributions D,
8347: po_distributions PD,
8348: po_lines PL,

Line 8415: FROM ap_invoices_all AI,

8411: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
8412: D.corrected_quantity, -- l_corrected_quantity
8413: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8414: NULL --line_source
8415: FROM ap_invoices_all AI,
8416: ap_invoices retain_ai, --bug 9242891 retained invoice
8417: ap_system_parameters_all ASP,
8418: ap_invoice_distributions D,
8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists

Line 8416: ap_invoices retain_ai, --bug 9242891 retained invoice

8412: D.corrected_quantity, -- l_corrected_quantity
8413: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8414: NULL --line_source
8415: FROM ap_invoices_all AI,
8416: ap_invoices retain_ai, --bug 9242891 retained invoice
8417: ap_system_parameters_all ASP,
8418: ap_invoice_distributions D,
8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists
8420: po_distributions PD,

Line 8453: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.' ||

8449: BEGIN
8450:
8451: l_api_name := 'CALCULATE_VARIANCE'; --bug 9242891
8452:
8453: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.' ||
8454: 'CALCULATE_VARIANCE<-'|| X_calling_sequence;
8455:
8456:
8457: --bug 9242891

Line 8459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_INVOICES_UTILITY_PKG.calculate_variance(+)');

8455:
8456:
8457: --bug 9242891
8458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_INVOICES_UTILITY_PKG.calculate_variance(+)');
8460: END IF; --bug 9242891
8461:
8462:
8463: --bug 9242891 select added to determine which cursor to open.

Line 8466: FROM AP_INVOICES_ALL ai,

8462:
8463: --bug 9242891 select added to determine which cursor to open.
8464: SELECT COUNT(*)
8465: INTO l_cnt
8466: FROM AP_INVOICES_ALL ai,
8467: AP_INVOICE_DISTRIBUTIONS aid
8468: WHERE aid.Invoice_Distribution_Id = X_DISTRIBUTION_ID
8469: AND ai.invoice_id = aid.invoice_id
8470: AND ai.invoice_type_lookup_code = 'RETAINAGE RELEASE';

Line 8704: from AP_INVOICES AI,

8700: l_debug_info := ' CALCULATE_VARIANCE - for PRICE CORRECTION';
8701:
8702: select nvl(AI.exchange_rate, 1)
8703: into l_corrected_inv_rate
8704: from AP_INVOICES AI,
8705: AP_INVOICE_DISTRIBUTIONS D
8706: where D.invoice_distribution_id = l_corrected_inv_dist_id
8707: and D.invoice_id = AI.invoice_id;
8708:

Line 8780: from AP_INVOICES AI,

8776: l_debug_info := ' CALCULATE_VARIANCE - for AMOUNT CORRECTION';
8777:
8778: select nvl(AI.exchange_rate, 1)
8779: into l_corrected_inv_rate
8780: from AP_INVOICES AI,
8781: AP_INVOICE_DISTRIBUTIONS D
8782: where D.invoice_distribution_id = l_corrected_inv_dist_id
8783: and D.invoice_id = AI.invoice_id;
8784: