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 487: ap_invoices AI

483: SELECT NVL(sla_ledger_cash_basis_flag, 'N')
484: INTO l_cash_basis
485: FROM ap_system_parameters ASP,
486: gl_sets_of_books SOB,
487: ap_invoices AI
488: WHERE AI.invoice_id = x_invoice_id
489: AND AI.org_id = ASP.org_id
490: AND asp.set_of_books_id = sob.set_of_books_id;
491:

Line 1159: ap_invoices.exchange_rate%TYPE;

1155: l_dist_total number;
1156: l_base_currency_code
1157: ap_system_parameters.base_currency_code%TYPE;
1158: l_exchange_rate
1159: ap_invoices.exchange_rate%TYPE;
1160: l_exchange_rate_type
1161: ap_invoices.exchange_rate_type%TYPE;
1162: l_exchange_date
1163: ap_invoices.exchange_date%TYPE;

Line 1161: ap_invoices.exchange_rate_type%TYPE;

1157: ap_system_parameters.base_currency_code%TYPE;
1158: l_exchange_rate
1159: ap_invoices.exchange_rate%TYPE;
1160: l_exchange_rate_type
1161: ap_invoices.exchange_rate_type%TYPE;
1162: l_exchange_date
1163: ap_invoices.exchange_date%TYPE;
1164: l_base_amount
1165: ap_invoices.base_amount%TYPE;

Line 1163: ap_invoices.exchange_date%TYPE;

1159: ap_invoices.exchange_rate%TYPE;
1160: l_exchange_rate_type
1161: ap_invoices.exchange_rate_type%TYPE;
1162: l_exchange_date
1163: ap_invoices.exchange_date%TYPE;
1164: l_base_amount
1165: ap_invoices.base_amount%TYPE;
1166: l_invoice_amount
1167: ap_invoices.invoice_amount%TYPE;

Line 1165: ap_invoices.base_amount%TYPE;

1161: ap_invoices.exchange_rate_type%TYPE;
1162: l_exchange_date
1163: ap_invoices.exchange_date%TYPE;
1164: l_base_amount
1165: ap_invoices.base_amount%TYPE;
1166: l_invoice_amount
1167: ap_invoices.invoice_amount%TYPE;
1168: l_invoice_currency_code
1169: ap_invoices.invoice_currency_code%TYPE;

Line 1167: ap_invoices.invoice_amount%TYPE;

1163: ap_invoices.exchange_date%TYPE;
1164: l_base_amount
1165: ap_invoices.base_amount%TYPE;
1166: l_invoice_amount
1167: ap_invoices.invoice_amount%TYPE;
1168: l_invoice_currency_code
1169: ap_invoices.invoice_currency_code%TYPE;
1170: l_last_update_login
1171: ap_invoices.last_update_login%TYPE;

Line 1169: ap_invoices.invoice_currency_code%TYPE;

1165: ap_invoices.base_amount%TYPE;
1166: l_invoice_amount
1167: ap_invoices.invoice_amount%TYPE;
1168: l_invoice_currency_code
1169: ap_invoices.invoice_currency_code%TYPE;
1170: l_last_update_login
1171: ap_invoices.last_update_login%TYPE;
1172: l_last_updated_by
1173: ap_invoices.last_updated_by%TYPE;

Line 1171: ap_invoices.last_update_login%TYPE;

1167: ap_invoices.invoice_amount%TYPE;
1168: l_invoice_currency_code
1169: ap_invoices.invoice_currency_code%TYPE;
1170: l_last_update_login
1171: ap_invoices.last_update_login%TYPE;
1172: l_last_updated_by
1173: ap_invoices.last_updated_by%TYPE;
1174: l_last_update_date
1175: ap_invoices.last_update_date%TYPE;

Line 1173: ap_invoices.last_updated_by%TYPE;

1169: ap_invoices.invoice_currency_code%TYPE;
1170: l_last_update_login
1171: ap_invoices.last_update_login%TYPE;
1172: l_last_updated_by
1173: ap_invoices.last_updated_by%TYPE;
1174: l_last_update_date
1175: ap_invoices.last_update_date%TYPE;
1176: l_invoice_distribution_id
1177: ap_invoice_distributions.invoice_distribution_id%TYPE;

Line 1175: ap_invoices.last_update_date%TYPE;

1171: ap_invoices.last_update_login%TYPE;
1172: l_last_updated_by
1173: ap_invoices.last_updated_by%TYPE;
1174: l_last_update_date
1175: ap_invoices.last_update_date%TYPE;
1176: l_invoice_distribution_id
1177: ap_invoice_distributions.invoice_distribution_id%TYPE;
1178: l_project_id
1179: ap_invoice_distributions.project_id%TYPE;

Line 1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;

1228: l_dist_attribute14 ap_invoice_distributions.attribute1%TYPE;
1229: l_dist_attribute15 ap_invoice_distributions.attribute1%TYPE;
1230: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1231: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;

Line 1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;

1229: l_dist_attribute15 ap_invoice_distributions.attribute1%TYPE;
1230: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1231: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;

Line 1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;

1230: l_dist_posted_flag ap_invoice_distributions.posted_flag%TYPE;
1231: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;

Line 1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;

1231: l_dist_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;

Line 1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;

1232: l_inv_attribute_category ap_invoices.attribute_category%TYPE;
1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;

Line 1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;

1233: l_inv_attribute1 ap_invoices.attribute1%TYPE;
1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;

Line 1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;

1234: l_inv_attribute2 ap_invoices.attribute1%TYPE;
1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;

Line 1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;

1235: l_inv_attribute3 ap_invoices.attribute1%TYPE;
1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;

Line 1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;

1236: l_inv_attribute4 ap_invoices.attribute1%TYPE;
1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;

Line 1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;

1237: l_inv_attribute5 ap_invoices.attribute1%TYPE;
1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;

Line 1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;

1238: l_inv_attribute6 ap_invoices.attribute1%TYPE;
1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;

Line 1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;

1239: l_inv_attribute7 ap_invoices.attribute1%TYPE;
1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;

Line 1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;

1240: l_inv_attribute8 ap_invoices.attribute1%TYPE;
1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1248: l_msg_application VARCHAR2(25);

Line 1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;

1241: l_inv_attribute9 ap_invoices.attribute1%TYPE;
1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1248: l_msg_application VARCHAR2(25);
1249: l_msg_type VARCHAR2(25);

Line 1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;

1242: l_inv_attribute10 ap_invoices.attribute1%TYPE;
1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1248: l_msg_application VARCHAR2(25);
1249: l_msg_type VARCHAR2(25);
1250: l_msg_token1 VARCHAR2(30);

Line 1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;

1243: l_inv_attribute11 ap_invoices.attribute1%TYPE;
1244: l_inv_attribute12 ap_invoices.attribute1%TYPE;
1245: l_inv_attribute13 ap_invoices.attribute1%TYPE;
1246: l_inv_attribute14 ap_invoices.attribute1%TYPE;
1247: l_inv_attribute15 ap_invoices.attribute1%TYPE;
1248: l_msg_application VARCHAR2(25);
1249: l_msg_type VARCHAR2(25);
1250: l_msg_token1 VARCHAR2(30);
1251: l_msg_token2 VARCHAR2(30);

Line 1257: ap_invoices.invoice_type_lookup_code%TYPE;

1253: l_msg_count NUMBER;
1254: l_msg_data VARCHAR2(30);
1255: l_billable_flag VARCHAR2(25);
1256: l_invoice_type_lookup_code
1257: ap_invoices.invoice_type_lookup_code%TYPE;
1258: l_chart_of_accounts_id NUMBER;
1259: l_DIST_CODE_COMBINATION_ID NUMBER;
1260: l_concat_ids Varchar2(2000);
1261: l_concat_segs Varchar2(2000);

Line 1276: l_org_id ap_invoices_all.org_id%type;

1272: l_round_amt_exists BOOLEAN := FALSE;
1273: l_rounded_amt NUMBER;
1274: --Bug 4539462 DBI logging
1275: l_dbi_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1276: l_org_id ap_invoices_all.org_id%type;
1277:
1278: l_base_amt NUMBER; --6892789
1279: l_modified_dist_rounding_amt NUMBER; --6892789
1280: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

Line 1300: FROM ap_invoices AI,

1296: AI.last_update_date,
1297: AIL.last_update_date ),
1298: AIL.line_number,
1299: AI.org_id
1300: FROM ap_invoices AI,
1301: ap_invoice_lines AIL
1302: WHERE AI.invoice_id = X_invoice_id
1303: AND AIL.invoice_id = AI.invoice_id
1304: AND AIL.line_number = NVL(X_line_number, AIL.line_number);

Line 1360: ap_invoices AI,

1356: AI.attribute14,
1357: AI.attribute15,
1358: gsob.chart_of_accounts_id
1359: FROM ap_invoice_distributions AID,
1360: ap_invoices AI,
1361: ap_suppliers PV,
1362: po_distributions PD,
1363: ap_system_parameters ap,
1364: gl_sets_of_books gsob

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

1404: -- l_base_currency_code
1405: --FROM financials_system_parameters FSP,
1406: -- ap_system_parameters SP;
1407:
1408: debug_info := 'select AP_INVOICES info';
1409:
1410: /*-----------------------------------------------------------------+
1411: | Fetch the invoice information that we need in order to update |
1412: | the distribution base amounts |

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

3573: ROUND((SUM(d2.amount) * i.exchange_rate)
3574: /MAX(f.minimum_accountable_unit))*
3575: MAX(f.minimum_accountable_unit))),
3576: d1.base_amount)
3577: FROM ap_invoices i, ap_invoice_distributions d2, fnd_currencies F
3578: WHERE d1.invoice_id = i.invoice_id
3579: AND d1.invoice_id = d2.invoice_id
3580: AND f.currency_code = X_Base_Currency_Code
3581: GROUP BY i.exchange_rate)

Line 3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3

3585: (SELECT d5.invoice_id, MAX(d5.distribution_line_number)
3586: FROM ap_invoice_distributions_all d5
3587: WHERE (d5.invoice_id, abs(d5.amount)) IN
3588: (SELECT i1.invoice_id , MAX(ABS(d3.amount))
3589: FROM ap_invoices_all i1, ap_invoice_distributions_all d3
3590: WHERE i1.invoice_id = X_Invoice_Id
3591: AND i1.invoice_id = d3.invoice_id
3592: AND d3.line_type_lookup_code <> 'TAX'
3593: AND NOT EXISTS

Line 3627: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,

3623: -- ap_invoice_distributions given a line number number and/or line record.
3624: -- It returns FALSE if an error is encountered.
3625: -----------------------------------------------------------------------
3626: FUNCTION Insert_Single_Dist_From_Line(
3627: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3628: X_invoice_id IN NUMBER,
3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

Line 3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

3625: -----------------------------------------------------------------------
3626: FUNCTION Insert_Single_Dist_From_Line(
3627: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3628: X_invoice_id IN NUMBER,
3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

Line 3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,

3626: FUNCTION Insert_Single_Dist_From_Line(
3627: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3628: X_invoice_id IN NUMBER,
3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

Line 3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

3627: X_batch_id IN AP_INVOICES.BATCH_ID%TYPE,
3628: X_invoice_id IN NUMBER,
3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3635: X_line_number IN NUMBER,

Line 3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

3628: X_invoice_id IN NUMBER,
3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3635: X_line_number IN NUMBER,
3636: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

Line 3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

3629: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3635: X_line_number IN NUMBER,
3636: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3637: X_line_source IN VARCHAR2,

Line 3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

3630: X_vendor_id IN AP_INVOICES.VENDOR_ID%TYPE,
3631: X_invoice_currency IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3635: X_line_number IN NUMBER,
3636: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3637: X_line_source IN VARCHAR2,
3638: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',

Line 3636: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

3632: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
3633: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
3634: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
3635: X_line_number IN NUMBER,
3636: X_invoice_lines_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
3637: X_line_source IN VARCHAR2,
3638: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',
3639: X_Validate_Info IN BOOLEAN DEFAULT TRUE,
3640: X_Error_Code OUT NOCOPY VARCHAR2,

Line 3792: --of ap_invoices_pkg.r_invoice_line_rec

3788: GLOBAL_ATTRIBUTE18,
3789: GLOBAL_ATTRIBUTE19,
3790: GLOBAL_ATTRIBUTE20,
3791: --ETAX: Invwkb, added included_tax_amount as modified the def
3792: --of ap_invoices_pkg.r_invoice_line_rec
3793: INCLUDED_TAX_AMOUNT,
3794: PRIMARY_INTENDED_USE,
3795: APPLICATION_ID,
3796: PRODUCT_TABLE,

Line 3811: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

3807: WHERE invoice_id = X_invoice_id
3808: AND line_number = X_line_number;
3809:
3810:
3811: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
3812:
3813: l_distribution_class
3814: AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
3815: l_dist_ccid

Line 3846: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

3842: debug_context VARCHAR2(2000);
3843: l_dist_code_concat VARCHAR2(2000);
3844: l_invoice_distribution_id
3845: ap_invoice_distributions.invoice_distribution_id%TYPE;
3846: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
3847: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
3848: l_web_parameter_id number; --Bug5003249
3849: l_employee_ccid number;
3850: l_message_text fnd_new_messages.message_text%type;

Line 3987: AP_INVOICES_PKG.get_expenditure_item_date(

3983: debug_info := 'Get expenditure item date and validate if PA related';
3984: IF (l_invoice_line_rec.project_id is not null) then
3985: IF (l_invoice_line_rec.expenditure_item_date is null) then
3986: l_invoice_line_rec.expenditure_item_date :=
3987: AP_INVOICES_PKG.get_expenditure_item_date(
3988: l_invoice_line_rec.invoice_id,
3989: X_invoice_date,
3990: l_open_GL_date,
3991: NULL,

Line 4053: FROM ap_invoices_all

4049: /* Bug 5102724 */
4050: BEGIN
4051: SELECT invoice_type_lookup_code
4052: INTO l_invoice_type_lookup_code
4053: FROM ap_invoices_all
4054: WHERE invoice_id = X_invoice_id;
4055: EXCEPTION
4056: WHEN no_data_found then
4057: NULL;

Line 4740: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,

4736: --------------------------------------------------------------------------
4737:
4738: FUNCTION Get_Proj_And_Acc_For_Chrg_Dist(
4739: X_invoice_id IN NUMBER,
4740: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
4741: X_vendor_id IN NUMBER,
4742: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
4743: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
4744: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

Line 4742: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,

4738: FUNCTION Get_Proj_And_Acc_For_Chrg_Dist(
4739: X_invoice_id IN NUMBER,
4740: X_invoice_date IN AP_INVOICES.INVOICE_DATE%TYPE,
4741: X_vendor_id IN NUMBER,
4742: X_invoice_currency_code IN AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE,
4743: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,
4744: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
4745: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
4746: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,

Line 4748: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,

4744: X_chart_of_accounts_id IN GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
4745: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
4746: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
4747: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
4748: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
4749: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
4750: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
4751: X_line_number IN NUMBER,
4752: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,

Line 4749: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,

4745: X_base_currency_code IN AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE,
4746: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
4747: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
4748: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
4749: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
4750: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
4751: X_line_number IN NUMBER,
4752: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,
4753: X_Period_Name IN AP_INVOICE_LINES.PERIOD_NAME%TYPE,

Line 4750: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,

4746: X_amount IN AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE,
4747: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,
4748: X_exchange_rate_type IN AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE,
4749: X_exchange_date IN AP_INVOICES.EXCHANGE_DATE%TYPE,
4750: X_exchange_rate IN AP_INVOICES.EXCHANGE_RATE%TYPE,
4751: X_line_number IN NUMBER,
4752: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE,
4753: X_Period_Name IN AP_INVOICE_LINES.PERIOD_NAME%TYPE,
4754: X_chrg_line_project_id IN AP_INVOICE_LINES.PROJECT_ID%TYPE,

Line 4816: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

4812: l_billable_flag VARCHAR2(25);
4813: l_unbuilt_flex VARCHAR2(240):='';
4814: l_reason_unbuilt_flex VARCHAR2(2000):='';
4815: l_error_found VARCHAR2(1) := 'N';
4816: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
4817: current_calling_sequence VARCHAR2(200);
4818: debug_context VARCHAR2(2000);
4819: debug_info VARCHAR2(100);
4820: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 4820: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

4816: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
4817: current_calling_sequence VARCHAR2(200);
4818: debug_context VARCHAR2(2000);
4819: debug_info VARCHAR2(100);
4820: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
4821: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
4822: l_web_parameter_id number; --Bug5003249
4823: l_employee_ccid number;
4824: l_message_text fnd_new_messages.message_text%TYPE;

Line 4858: X_expenditure_item_date := AP_INVOICES_PKG.get_expenditure_item_date(

4854: -------------------------------------------------------------------
4855: IF (X_project_id IS NOT NULL AND X_item_dist_project_id IS NOT NULL) then
4856: user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4857:
4858: X_expenditure_item_date := AP_INVOICES_PKG.get_expenditure_item_date(
4859: X_invoice_id,
4860: X_invoice_date,
4861: X_GL_date,
4862: X_item_po_dist_id,

Line 4912: FROM ap_invoices_all

4908: /* Bug 5102724 */
4909: BEGIN
4910: SELECT invoice_type_lookup_code
4911: INTO l_invoice_type_lookup_code
4912: FROM ap_invoices_all
4913: WHERE invoice_id = X_invoice_id;
4914: EXCEPTION
4915: WHEN no_data_found then
4916: NULL;

Line 5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

5336: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;
5337: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

Line 5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

5337: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;

5338: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

5339: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
5347: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;

Line 5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

5340: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
5347: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
5348: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;

Line 5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

5341: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
5347: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
5348: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;
5349: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;

Line 5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

5342: l_invoice_amount AP_INVOICES.INVOICE_AMOUNT%TYPE;
5343: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
5344: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
5345: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
5346: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
5347: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE;
5348: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE;
5349: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;
5350: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;

Line 5585: FROM ap_invoices

5581: l_exchange_rate_type,
5582: l_exchange_date,
5583: l_invoice_currency_code,
5584: l_invoice_amount
5585: FROM ap_invoices
5586: WHERE invoice_id = X_invoice_id;
5587:
5588: EXCEPTION
5589: When no_data_found then

Line 5626: ap_invoices_all ai

5622: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
5623: SUM(ail.amount) )
5624: INTO l_sum_lines_amount
5625: FROM ap_invoice_lines_all ail,
5626: ap_invoices_all ai
5627: WHERE ai.invoice_id = ail.invoice_id
5628: AND ail.invoice_id = X_invoice_id
5629: AND ail.line_type_lookup_code NOT IN ('AWT')
5630: /*bugfix:5685469*/

Line 6678: ap_invoices ai

6674:
6675: SELECT nvl(ai.invoice_num,0)
6676: INTO l_inv_num
6677: FROM ap_invoice_distributions aid,
6678: ap_invoices ai
6679: WHERE aid.invoice_distribution_id = X_invoice_dist_id
6680: AND aid.invoice_id = ai.invoice_id;
6681:
6682: RETURN(l_inv_num);

Line 6783: l_inv_currency_code ap_invoices.invoice_currency_code%TYPE;

6779: X_DEBUG_CONTEXT IN OUT NOCOPY VARCHAR2,
6780: X_CALLING_SEQUENCE IN OUT NOCOPY VARCHAR2) Return Boolean
6781:
6782: IS
6783: l_inv_currency_code ap_invoices.invoice_currency_code%TYPE;
6784: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
6785: l_dist_line_type VARCHAR2(25);
6786: l_inv_price ap_invoice_distributions.unit_price%TYPE;
6787: l_qty_invoiced NUMBER;

Line 6792: l_inv_rate ap_invoices.exchange_rate%TYPE;

6788: l_po_qty NUMBER;
6789: l_po_price po_line_locations.price_override%TYPE;
6790: l_po_rate NUMBER;
6791: l_rtxn_rate NUMBER;
6792: l_inv_rate ap_invoices.exchange_rate%TYPE;
6793: l_match_option po_line_locations.match_option%TYPE;
6794: l_rtxn_uom VARCHAR2(25);
6795: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
6796: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

Line 6809: l_corrected_inv_rate ap_invoices.exchange_rate%TYPE;

6805:
6806: l_original_dist_base_amt NUMBER;
6807: l_original_dist_amt NUMBER;
6808:
6809: l_corrected_inv_rate ap_invoices.exchange_rate%TYPE;
6810: current_calling_sequence VARCHAR2(2000);
6811: l_debug_info VARCHAR2(100);
6812:
6813: l_match_basis po_line_types.matching_basis%TYPE; -- Amount Based Matching

Line 6843: FROM ap_invoices_all AI,

6839: D.dist_match_type, -- l_dist_match_type
6840: D.corrected_invoice_dist_id, -- l_corrected_invoice_dist_id
6841: D.corrected_quantity, -- l_corrected_quantity
6842: PLL.matching_basis -- l_match_basis /* Amount Based Matching */
6843: FROM ap_invoices_all AI,
6844: ap_system_parameters_all ASP,
6845: ap_invoice_distributions D,
6846: po_distributions PD,
6847: po_lines PL,

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

6866: 'RETROACCRUAL'); --Retropricing
6867:
6868: BEGIN
6869:
6870: current_calling_sequence := 'AP_INVOICES_UTILITY_PKG.' ||
6871: 'CALCULATE_VARIANCE<-'|| X_calling_sequence;
6872:
6873: /*-----------------------------------------------------------------+
6874: | Step 0 - Open Cursor to Initialize the all the information |

Line 7013: from AP_INVOICES AI,

7009: l_debug_info := ' CALCULATE_VARIANCE - for PRICE CORRECTION';
7010:
7011: select nvl(AI.exchange_rate, 1)
7012: into l_corrected_inv_rate
7013: from AP_INVOICES AI,
7014: AP_INVOICE_DISTRIBUTIONS D
7015: where D.invoice_distribution_id = l_corrected_inv_dist_id
7016: and D.invoice_id = AI.invoice_id;
7017:

Line 7078: from AP_INVOICES AI,

7074: l_debug_info := ' CALCULATE_VARIANCE - for AMOUNT CORRECTION';
7075:
7076: select nvl(AI.exchange_rate, 1)
7077: into l_corrected_inv_rate
7078: from AP_INVOICES AI,
7079: AP_INVOICE_DISTRIBUTIONS D
7080: where D.invoice_distribution_id = l_corrected_inv_dist_id
7081: and D.invoice_id = AI.invoice_id;
7082: