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.

[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES

Line 256: ap_invoice_lines_all ail

252: If (X_LINE_NUMBER is null) then
253: SELECT NVL(SUM(aid.amount), 0)
254: INTO X_Total
255: FROM ap_invoice_distributions_all aid,
256: ap_invoice_lines_all ail
257: WHERE ail.invoice_id = X_Invoice_Id
258: AND ail.invoice_id = aid.invoice_id
259: AND ail.line_number = aid.invoice_line_number
260: AND ((aid.line_type_lookup_code NOT IN ('PREPAY', 'AWT', 'RETAINAGE')

Line 269: ap_invoice_lines_all ail

265: else
266: SELECT NVL(SUM(aid.amount), 0)
267: INTO X_Total
268: FROM ap_invoice_distributions_all aid,
269: ap_invoice_lines_all ail
270: WHERE ail.invoice_id = X_Invoice_Id
271: AND ail.invoice_id = aid.invoice_id
272: AND ail.line_number = aid.invoice_line_number
273: AND ail.line_number = X_LINE_NUMBER

Line 704: -- Called from ap_invoice_lines_pkg.insert_from_dist_set or from Import

700: -- FUNCTION insert_from_dist_set inserts records into
701: -- ap_invoice_distributions given a line number, distribution set id and
702: -- table of distribution information. It returns FALSE if an error
703: -- is encountered.
704: -- Called from ap_invoice_lines_pkg.insert_from_dist_set or from Import
705: -----------------------------------------------------------------------
706: FUNCTION Insert_From_Dist_Set(
707: X_batch_id IN NUMBER,
708: X_invoice_id IN NUMBER,

Line 710: X_dist_tab IN AP_INVOICE_LINES_PKG.dist_tab_type,

706: FUNCTION Insert_From_Dist_Set(
707: X_batch_id IN NUMBER,
708: X_invoice_id IN NUMBER,
709: X_line_number IN NUMBER,
710: X_dist_tab IN AP_INVOICE_LINES_PKG.dist_tab_type,
711: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',
712: X_Debug_Info OUT NOCOPY VARCHAR2,
713: X_Debug_Context OUT NOCOPY VARCHAR2,
714: X_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN

Line 738: l_line_type_lookup_code ap_invoice_lines_all.line_type_lookup_code%TYPE; --Bug16324208

734: --Bug#10241241
735: l_set_of_books_id NUMBER;
736: l_chart_of_accounts_id NUMBER;
737: l_dist_updated NUMBER;
738: l_line_type_lookup_code ap_invoice_lines_all.line_type_lookup_code%TYPE; --Bug16324208
739:
740: BEGIN
741:
742: --------------------------------------------------------------------------

Line 757: FROM ap_invoice_lines_all

753: debug_info := 'Get line_type_lookup_code';
754: BEGIN
755: SELECT line_type_lookup_code
756: INTO l_line_type_lookup_code
757: FROM ap_invoice_lines_all
758: WHERE invoice_id = X_invoice_id
759: AND line_number = X_line_number;
760:
761: EXCEPTION

Line 1195: UPDATE AP_INVOICE_LINES

1191: ----------------------------------------------------------------------------
1192: debug_info := 'Setting generate distributions flag to Done';
1193: if (l_distribution_class = 'PERMANENT') then
1194: BEGIN
1195: UPDATE AP_INVOICE_LINES
1196: SET GENERATE_DISTS = 'D'
1197: WHERE invoice_id = X_invoice_id
1198: AND line_number = X_line_number;
1199: EXCEPTION

Line 1353: ap_invoice_lines.line_number%TYPE;

1349: debug_info VARCHAR2(100);
1350: debug_context VARCHAR2(2000);
1351: l_key_value_list ap_dbi_pkg.r_dbi_key_value_arr; -- bug 9772522
1352: l_line_number
1353: ap_invoice_lines.line_number%TYPE;
1354: l_rounded_dist_id
1355: ap_invoice_distributions.invoice_distribution_id%type;
1356: l_round_amt_exists BOOLEAN := FALSE;
1357: l_rounded_amt NUMBER;

Line 1364: l_round_dist_id_list AP_INVOICE_LINES_PKG.distribution_id_tab_type; --6892789

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
1365:
1366: cursor invoice_line_cursor is
1367: SELECT exchange_rate,
1368: exchange_rate_type,

Line 1385: ap_invoice_lines AIL

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);
1389:

Line 1667: l_round_amt_exists := AP_INVOICE_LINES_PKG.round_base_amts(

1663: distribution base amt goes to -ve value (amount being +ve) so in such case,
1664: adjust dist base amount upto zero and adjust the remaing amount in another
1665: distribution having next max amount */
1666: -- get the distributions which can be adjusted
1667: l_round_amt_exists := AP_INVOICE_LINES_PKG.round_base_amts(
1668: x_invoice_id => X_invoice_id,
1669: x_line_number => l_line_number,
1670: x_reporting_ledger_id => NULL,
1671: x_round_dist_id_list => l_round_dist_id_list,

Line 3976: FROM ap_invoice_lines_all

3972: --bugfix:4674194
3973: SHIP_TO_LOCATION_ID,
3974: --bug7022001
3975: PAY_AWT_GROUP_ID
3976: FROM ap_invoice_lines_all
3977: WHERE invoice_id = X_invoice_id
3978: AND line_number = X_line_number;
3979:
3980:

Line 3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

3990: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3991: l_assets_tracking_flag
3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3995: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3996: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3997: user_id NUMBER;
3998: l_msg_application VARCHAR2(25);

Line 3995: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

3991: l_assets_tracking_flag
3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3995: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3996: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3997: user_id NUMBER;
3998: l_msg_application VARCHAR2(25);
3999: l_msg_type VARCHAR2(25);

Line 3996: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;

3992: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3993: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3994: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3995: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3996: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3997: user_id NUMBER;
3998: l_msg_application VARCHAR2(25);
3999: l_msg_type VARCHAR2(25);
4000: l_msg_token1 VARCHAR2(30);

Line 4324: from ap_invoice_lines

4320: End;
4321:
4322: select WEB_PARAMETER_ID
4323: into l_web_parameter_id
4324: from ap_invoice_lines
4325: where invoice_id = X_invoice_id
4326: AND line_number = X_line_number;
4327:
4328: /* Bug 5102724 */

Line 5021: UPDATE AP_INVOICE_LINES

5017: ----------------------------------------------------------------------------
5018: debug_info := 'Setting generate distributions flag to Done';
5019: IF (l_distribution_class = 'PERMANENT') then
5020: BEGIN
5021: UPDATE AP_INVOICE_LINES
5022: SET GENERATE_DISTS = 'D'
5023: WHERE invoice_id = X_invoice_id
5024: AND line_number = l_invoice_line_rec.line_number;
5025: EXCEPTION

Line 5225: FROM ap_invoice_lines_all

5221: , REFERENCE_KEY4
5222: , REFERENCE_KEY5
5223: , SHIP_TO_LOCATION_ID
5224: , PAY_AWT_GROUP_ID
5225: FROM ap_invoice_lines_all
5226: WHERE invoice_id = X_invoice_id
5227: AND line_number = X_line_number;
5228:
5229:

Line 5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

5235: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5241: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5242: user_id NUMBER;
5243: l_msg_application VARCHAR2(25);

Line 5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

5236: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5241: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5242: user_id NUMBER;
5243: l_msg_application VARCHAR2(25);
5244: l_msg_type VARCHAR2(25);

Line 5241: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;

5237: l_assets_tracking_flag AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
5238: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
5239: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5240: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5241: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5242: user_id NUMBER;
5243: l_msg_application VARCHAR2(25);
5244: l_msg_type VARCHAR2(25);
5245: l_msg_token1 VARCHAR2(30);

Line 5987: UPDATE AP_INVOICE_LINES

5983: ----------------------------------------------------------------------------
5984: debug_info := 'Setting generate distributions flag to Done';
5985: IF (l_distribution_class = 'PERMANENT') then
5986: BEGIN
5987: UPDATE AP_INVOICE_LINES
5988: SET GENERATE_DISTS = 'D'
5989: WHERE invoice_id = X_invoice_id
5990: AND line_number = l_invoice_line_rec.line_number;
5991: EXCEPTION

Line 6026: X_sob_id IN AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE,

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,
6030: X_base_amount IN AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE,

Line 6035: X_GL_Date IN AP_INVOICE_LINES.ACCOUNTING_DATE%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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,

Line 6036: X_Period_Name IN AP_INVOICE_LINES.PERIOD_NAME%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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,

Line 6037: X_chrg_line_project_id IN AP_INVOICE_LINES.PROJECT_ID%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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,

Line 6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,

Line 6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,

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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,

Line 6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%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,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,

Line 6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,

6037: X_chrg_line_project_id IN AP_INVOICE_LINES.PROJECT_ID%TYPE,
6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
6045: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,

Line 6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,

6038: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
6045: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
6046: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,

Line 6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,

6039: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
6045: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
6046: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
6047: X_item_dist_award_id IN AP_INVOICE_DISTRIBUTIONS.award_ID%TYPE,

Line 6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,

6040: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
6041: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
6042: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
6043: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
6044: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
6045: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
6046: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
6047: X_item_dist_award_id IN AP_INVOICE_DISTRIBUTIONS.award_ID%TYPE,
6048: X_item_dist_expenditure_type IN AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,

Line 6054: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,

6050: X_item_assets_track_flag IN AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE,
6051: X_item_asset_book_type_code IN AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE,
6052: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
6053: X_chrg_line_default_ccid IN NUMBER,
6054: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
6055: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
6056: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
6057: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
6058: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,

Line 6055: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,

6051: X_item_asset_book_type_code IN AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE,
6052: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
6053: X_chrg_line_default_ccid IN NUMBER,
6054: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
6055: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
6056: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
6057: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
6058: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
6059: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,

Line 6056: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,

6052: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
6053: X_chrg_line_default_ccid IN NUMBER,
6054: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
6055: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
6056: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
6057: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
6058: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
6059: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,
6060: X_item_rcv_trx_id IN AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE,

Line 6057: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,

6053: X_chrg_line_default_ccid IN NUMBER,
6054: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
6055: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
6056: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
6057: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
6058: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
6059: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,
6060: X_item_rcv_trx_id IN AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE,
6061: X_pa_allows_overrides IN VARCHAR2,

Line 6065: X_award_id OUT NOCOPY AP_INVOICE_LINES.award_ID%TYPE,

6061: X_pa_allows_overrides IN VARCHAR2,
6062: X_allow_po_override IN VARCHAR2,
6063: X_project_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
6064: X_task_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
6065: X_award_id OUT NOCOPY AP_INVOICE_LINES.award_ID%TYPE,
6066: X_expenditure_type OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
6067: X_expenditure_org_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
6068: X_expenditure_item_date OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
6069: X_pa_addition_flag OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.PA_ADDITION_FLAG%TYPE,

Line 6077: X_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE) --bug 5386396

6073: X_asset_category_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
6074: X_error_code OUT NOCOPY VARCHAR2,
6075: X_msg_application OUT NOCOPY VARCHAR2,
6076: X_msg_data OUT NOCOPY VARCHAR2,
6077: X_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE) --bug 5386396
6078: RETURN BOOLEAN
6079: IS
6080:
6081: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;

Line 6220: from ap_invoice_lines

6216: l_invoice_attribute_rec.line_attribute12,
6217: l_invoice_attribute_rec.line_attribute13,
6218: l_invoice_attribute_rec.line_attribute14,
6219: l_invoice_attribute_rec.line_attribute15
6220: from ap_invoice_lines
6221: where invoice_id = X_invoice_id
6222: AND line_number = X_line_number;
6223:
6224: /* Bug 5102724 */

Line 6655: FROM AP_invoice_lines AIL,

6651: CURSOR applicable_lines_cur IS
6652: SELECT AIL.line_number,
6653: AIL.amount,
6654: sum(AID.amount)
6655: FROM AP_invoice_lines AIL,
6656: AP_invoice_distributions_all AID
6657: WHERE AIL.invoice_id = X_invoice_id
6658: AND nvl(AIL.discarded_flag, 'N') = 'N'
6659: AND nvl(AIL.cancelled_flag, 'N') = 'N'

Line 6697: l_org_id AP_INVOICE_LINES.ORG_ID%TYPE;

6693:
6694:
6695: l_batch_id AP_INVOICE_DISTRIBUTIONS.BATCH_ID%TYPE;
6696: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
6697: l_org_id AP_INVOICE_LINES.ORG_ID%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;

Line 6698: l_sob_id AP_INVOICE_LINES.SET_OF_BOOKS_ID%TYPE;

6694:
6695: l_batch_id AP_INVOICE_DISTRIBUTIONS.BATCH_ID%TYPE;
6696: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
6697: l_org_id AP_INVOICE_LINES.ORG_ID%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;

Line 6709: l_assets_tracking_flag AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;

Line 6710: l_asset_book_type_code AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;

Line 6711: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;

Line 6712: l_line_amount AP_INVOICE_LINES.AMOUNT%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;

Line 6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;

Line 6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%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;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;

Line 6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;

6711: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;
6712: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;

Line 6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;

6712: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;

Line 6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;

6713: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;

Line 6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;

6714: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;

Line 6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;

6715: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;

Line 6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;

6716: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;

Line 6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;

6717: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;

Line 6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;

6718: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id

Line 6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;

6719: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;

Line 6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;

6720: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;

6721: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
6722: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;

Line 6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;

6723: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;

Line 6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

6724: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:

Line 6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;

6725: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001

Line 6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;

6726: l_expenditure_organization_id
6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:

Line 6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;

6727: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
6728: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;

Line 6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001

6729: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
6730: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

Line 6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;

6731: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6738: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
6739: l_invoice_distribution_id

Line 6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;

6732:
6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6738: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
6739: l_invoice_distribution_id
6740: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

Line 6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;

6733: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6738: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
6739: l_invoice_distribution_id
6740: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
6741: l_po_distribution_id AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;

Line 6738: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;

6734:
6735: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
6736: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
6737: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
6738: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
6739: l_invoice_distribution_id
6740: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
6741: l_po_distribution_id AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
6742: l_rcv_transaction_id AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE;

Line 6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;

6757: AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE;
6758: l_dist_asset_category_id
6759: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
6760: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;

Line 6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;

6758: l_dist_asset_category_id
6759: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
6760: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;

Line 6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;

Line 6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;

6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;

Line 6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;

6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;

Line 6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;

6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445

Line 6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;

6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445
6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;

Line 6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;

6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445
6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;
6779: l_reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE;

Line 6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;

6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
6773: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445
6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;
6779: l_reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE;
6780:

Line 6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;

6774: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445
6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;
6779: l_reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE;
6780:
6781: l_msg_application VARCHAR2(25);
6782: l_msg_data VARCHAR2(200); /*bug12612482 changed from 30 to 200*/

Line 6779: l_reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE;

6775: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6776: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
6777: --Bug9296445
6778: l_reference_1 AP_INVOICE_LINES.REFERENCE_1%TYPE;
6779: l_reference_2 AP_INVOICE_LINES.REFERENCE_2%TYPE;
6780:
6781: l_msg_application VARCHAR2(25);
6782: l_msg_data VARCHAR2(200); /*bug12612482 changed from 30 to 200*/
6783: i BINARY_INTEGER := 0;

Line 6802: l_chrg_line_rec ap_invoice_lines_all%rowtype;

6798: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
6799:
6800: -- Bug 5114543
6801: l_max_dist_line_num NUMBER :=0;
6802: l_chrg_line_rec ap_invoice_lines_all%rowtype;
6803: l_dummy VARCHAR2(30);
6804:
6805: l_country_code VARCHAR2(20); --bug 9169915
6806: l_stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE; --Bug#10241241

Line 6806: l_stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE; --Bug#10241241

6802: l_chrg_line_rec ap_invoice_lines_all%rowtype;
6803: l_dummy VARCHAR2(30);
6804:
6805: l_country_code VARCHAR2(20); --bug 9169915
6806: l_stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE; --Bug#10241241
6807: l_dist_updated NUMBER; --Bug#10241241
6808: -- Bug 13841774. Start.
6809: l_copy_line_dff_flag VARCHAR2(1);
6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;

Line 6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;

6806: l_stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE; --Bug#10241241
6807: l_dist_updated NUMBER; --Bug#10241241
6808: -- Bug 13841774. Start.
6809: l_copy_line_dff_flag VARCHAR2(1);
6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;
6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;

Line 6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;

6807: l_dist_updated NUMBER; --Bug#10241241
6808: -- Bug 13841774. Start.
6809: l_copy_line_dff_flag VARCHAR2(1);
6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;
6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;

Line 6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;

6808: -- Bug 13841774. Start.
6809: l_copy_line_dff_flag VARCHAR2(1);
6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;
6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;

Line 6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;

6809: l_copy_line_dff_flag VARCHAR2(1);
6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;
6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;

Line 6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;

6810: l_line_source AP_INVOICE_LINES.LINE_SOURCE%TYPE;
6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;

Line 6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;

6811: l_attribute_category AP_INVOICE_LINES.ATTRIBUTE_CATEGORY%TYPE;
6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;

Line 6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;

6812: l_attribute1 AP_INVOICE_LINES.ATTRIBUTE1%TYPE;
6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;

Line 6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;

6813: l_attribute2 AP_INVOICE_LINES.ATTRIBUTE2%TYPE;
6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;

Line 6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;

6814: l_attribute3 AP_INVOICE_LINES.ATTRIBUTE3%TYPE;
6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;

Line 6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;

6815: l_attribute4 AP_INVOICE_LINES.ATTRIBUTE4%TYPE;
6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;

Line 6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;

6816: l_attribute5 AP_INVOICE_LINES.ATTRIBUTE5%TYPE;
6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;

Line 6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;

6817: l_attribute6 AP_INVOICE_LINES.ATTRIBUTE6%TYPE;
6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;

Line 6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;

6818: l_attribute7 AP_INVOICE_LINES.ATTRIBUTE7%TYPE;
6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;
6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;

Line 6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;

6819: l_attribute8 AP_INVOICE_LINES.ATTRIBUTE8%TYPE;
6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;
6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;
6827: -- Bug 13841774. End.

Line 6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;

6820: l_attribute9 AP_INVOICE_LINES.ATTRIBUTE9%TYPE;
6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;
6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;
6827: -- Bug 13841774. End.
6828:

Line 6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;

6821: l_attribute10 AP_INVOICE_LINES.ATTRIBUTE10%TYPE;
6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;
6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;
6827: -- Bug 13841774. End.
6828:
6829: BEGIN

Line 6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;

6822: l_attribute11 AP_INVOICE_LINES.ATTRIBUTE11%TYPE;
6823: l_attribute12 AP_INVOICE_LINES.ATTRIBUTE12%TYPE;
6824: l_attribute13 AP_INVOICE_LINES.ATTRIBUTE13%TYPE;
6825: l_attribute14 AP_INVOICE_LINES.ATTRIBUTE14%TYPE;
6826: l_attribute15 AP_INVOICE_LINES.ATTRIBUTE15%TYPE;
6827: -- Bug 13841774. End.
6828:
6829: BEGIN
6830:

Line 6942: FROM ap_invoice_lines

6938: l_attribute13,
6939: l_attribute14,
6940: l_attribute15
6941: -- Bug 13841774. End.
6942: FROM ap_invoice_lines
6943: WHERE invoice_id = X_invoice_id
6944: AND line_number = X_line_number;
6945:
6946: EXCEPTION

Line 6977: from ap_invoice_lines_all ail

6973: -- continue with creation of charge distributions based on the allocation.
6974:
6975: select ail.*
6976: into l_chrg_line_rec
6977: from ap_invoice_lines_all ail
6978: where invoice_id = X_invoice_id
6979: and line_number = X_line_number;
6980:
6981: if not ap_invoice_lines_pkg.reverse_charge_distributions

Line 6981: if not ap_invoice_lines_pkg.reverse_charge_distributions

6977: from ap_invoice_lines_all ail
6978: where invoice_id = X_invoice_id
6979: and line_number = X_line_number;
6980:
6981: if not ap_invoice_lines_pkg.reverse_charge_distributions
6982: (p_inv_line_rec => l_chrg_line_rec
6983: ,p_calling_mode => l_dummy
6984: ,x_error_code => x_error_code
6985: ,x_debug_info => debug_info

Line 7062: FROM ap_invoice_lines_all ail,

7058: SELECT DECODE(NVL(ai.net_of_retainage_flag, 'N'),
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')

Line 7099: FROM ap_invoice_lines_all AIL

7095:
7096: BEGIN
7097: SELECT count(*)
7098: INTO l_count_undistributed_lines
7099: FROM ap_invoice_lines_all AIL
7100: WHERE AIL.invoice_id = X_invoice_id
7101: AND AIL.line_type_lookup_code = 'ITEM'
7102: AND NVL(AIL.match_type,'NOT_MATCHED') NOT IN
7103: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')

Line 7130: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL

7126: BEGIN
7127:
7128: SELECT count(*)
7129: INTO l_count_undistributed_lines
7130: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL
7131: WHERE AIL.invoice_id = X_invoice_id
7132: AND ARL.invoice_id = X_invoice_id
7133: AND ARL.chrg_invoice_line_number = X_line_number
7134: AND ARL.to_invoice_line_number = AIL.line_number

Line 7405: l_max_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num

7401: l_max_base_alloc := 0;
7402: l_running_total_base_amt := 0;
7403:
7404: -- Bug 5114543
7405: l_max_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num
7406: (x_invoice_id, x_line_number) + 1;
7407:
7408: FOR t IN 0..l_alloc_line_tab.COUNT-1 LOOP
7409: l_running_total_alloc := 0;

Line 7964: FROM ap_invoice_lines AIL, --Charge line

7960: --ETAX: Invwkb
7961: ail.primary_intended_use, -- intended_use
7962: 'N', -- rcv_charge_addition_flag
7963: l_pay_awt_group_id -- pay_awt_group_id 7022001
7964: FROM ap_invoice_lines AIL, --Charge line
7965: ap_invoice_lines AIL1, --ITEM Line
7966: ap_invoice_distributions aid
7967: WHERE ail.invoice_id = X_invoice_id
7968: AND ail.line_number = X_line_number

Line 7965: ap_invoice_lines AIL1, --ITEM Line

7961: ail.primary_intended_use, -- intended_use
7962: 'N', -- rcv_charge_addition_flag
7963: l_pay_awt_group_id -- pay_awt_group_id 7022001
7964: FROM ap_invoice_lines AIL, --Charge line
7965: ap_invoice_lines AIL1, --ITEM Line
7966: ap_invoice_distributions aid
7967: WHERE ail.invoice_id = X_invoice_id
7968: AND ail.line_number = X_line_number
7969: AND aid.invoice_id = ail.invoice_id

Line 8023: UPDATE AP_INVOICE_LINES

8019: -- generate_dists on the charge line should be set to 'Done'
8020: -- when the line amount equals the distributions total.
8021:
8022: BEGIN
8023: UPDATE AP_INVOICE_LINES
8024: SET GENERATE_DISTS = 'D'
8025: WHERE invoice_id = X_invoice_id
8026: AND line_number = X_line_number
8027: AND amount = (select sum(amount)

Line 8057: from ap_invoice_lines_all ail,

8053: WHERE invoice_id = X_invoice_id
8054: AND chrg_invoice_line_number = X_line_number
8055: AND exists
8056: (select 'Line Amount Equals Distribution Total'
8057: from ap_invoice_lines_all ail,
8058: ap_invoice_distributions_all aid
8059: where ail.invoice_id = aid.invoice_id
8060: and ail.line_number = aid.invoice_line_number
8061: and ail.invoice_id = X_invoice_id

Line 8313: l_line_source ap_invoice_lines.line_source%TYPE; --Bug#10416960

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
8313: l_line_source ap_invoice_lines.line_source%TYPE; --Bug#10416960
8314:
8315: cursor invoice_dist_cursor is
8316: SELECT AI.invoice_currency_code, -- l_inv_currency_code
8317: ASP.base_currency_code, -- l_base_currency_code

Line 8353: AP_INVOICE_LINES_ALL ail --bug#10416960

8349: po_line_types PLT, -- Amount Based Matching
8350: po_line_locations PLL,
8351: rcv_transactions RTXN,
8352: rcv_shipment_lines RSL,
8353: AP_INVOICE_LINES_ALL ail --bug#10416960
8354: WHERE AI.invoice_id = D.invoice_id
8355: AND D.invoice_distribution_id = X_distribution_id
8356: AND AIL.invoice_id = D.invoice_id
8357: AND AIL.line_number=D.invoice_line_number

Line 9118: TYPE INVOICE_LINE_NUMBER_LIST IS TABLE OF ap_invoice_lines.line_number%TYPE;

9114: (P_Invoice_Id IN NUMBER,
9115: P_Invoice_Line_Number IN NUMBER DEFAULT NULL,
9116: P_Calling_Sequence IN VARCHAR2) IS
9117:
9118: TYPE INVOICE_LINE_NUMBER_LIST IS TABLE OF ap_invoice_lines.line_number%TYPE;
9119: l_line_number_tab INVOICE_LINE_NUMBER_LIST;
9120: l_debug_info VARCHAR2(2000);
9121: current_calling_sequence VARCHAR2(2000);
9122: l_line_number NUMBER;

Line 9147: l_debug_info := 'Updating ap_invoice_lines';

9143: WHERE invoice_id = p_invoice_id
9144: AND invoice_line_number = NVL(p_invoice_line_number, invoice_line_number)
9145: AND distribution_class = 'CANDIDATE';
9146:
9147: l_debug_info := 'Updating ap_invoice_lines';
9148:
9149: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
9150:
9151: l_line_number := l_line_number_tab(uniq_values);

Line 9153: UPDATE ap_invoice_lines_all ail

9149: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
9150:
9151: l_line_number := l_line_number_tab(uniq_values);
9152:
9153: UPDATE ap_invoice_lines_all ail
9154: SET generate_dists = 'D'
9155: WHERE nvl(ail.generate_dists,'N') = 'Y'
9156: AND invoice_id = p_invoice_id
9157: AND ail.line_number = l_line_number_tab(uniq_values);

Line 9171: FROM ap_invoice_lines ail

9167: SET STATUS = 'EXECUTED'
9168: WHERE alr.invoice_id = p_invoice_id
9169: AND alr.chrg_invoice_line_number = l_line_number_tab(uniq_values)
9170: AND EXISTS (SELECT 'Valid charge line'
9171: FROM ap_invoice_lines ail
9172: WHERE ail.invoice_id = p_invoice_id --bug 5052657
9173: AND ail.line_number = alr.chrg_invoice_line_number
9174: AND nvl(ail.generate_dists,'N') = 'D'
9175: AND ail.line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS'));