[Home] [Help]
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')
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;
692: -- FUNCTION insert_from_dist_set inserts records into
693: -- ap_invoice_distributions given a line number, distribution set id and
694: -- table of distribution information. It returns FALSE if an error
695: -- is encountered.
696: -- Called from ap_invoice_lines_pkg.insert_from_dist_set or from Import
697: -----------------------------------------------------------------------
698: FUNCTION Insert_From_Dist_Set(
699: X_batch_id IN NUMBER,
700: X_invoice_id IN NUMBER,
698: FUNCTION Insert_From_Dist_Set(
699: X_batch_id IN NUMBER,
700: X_invoice_id IN NUMBER,
701: X_line_number IN NUMBER,
702: X_dist_tab IN AP_INVOICE_LINES_PKG.dist_tab_type,
703: X_Generate_Permanent IN VARCHAR2 DEFAULT 'N',
704: X_Debug_Info OUT NOCOPY VARCHAR2,
705: X_Debug_Context OUT NOCOPY VARCHAR2,
706: X_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
1107: ----------------------------------------------------------------------------
1108: debug_info := 'Setting generate distributions flag to Done';
1109: if (l_distribution_class = 'PERMANENT') then
1110: BEGIN
1111: UPDATE AP_INVOICE_LINES
1112: SET GENERATE_DISTS = 'D'
1113: WHERE invoice_id = X_invoice_id
1114: AND line_number = X_line_number;
1115: EXCEPTION
1265: debug_info VARCHAR2(100);
1266: debug_context VARCHAR2(2000);
1267: l_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1268: l_line_number
1269: ap_invoice_lines.line_number%TYPE;
1270: l_rounded_dist_id
1271: ap_invoice_distributions.invoice_distribution_id%type;
1272: l_round_amt_exists BOOLEAN := FALSE;
1273: l_rounded_amt NUMBER;
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
1281:
1282: cursor invoice_line_cursor is
1283: SELECT exchange_rate,
1284: exchange_rate_type,
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);
1305:
1570: distribution base amt goes to -ve value (amount being +ve) so in such case,
1571: adjust dist base amount upto zero and adjust the remaing amount in another
1572: distribution having next max amount */
1573: -- get the distributions which can be adjusted
1574: l_round_amt_exists := AP_INVOICE_LINES_PKG.round_base_amts(
1575: x_invoice_id => X_invoice_id,
1576: x_line_number => l_line_number,
1577: x_reporting_ledger_id => NULL,
1578: x_round_dist_id_list => l_round_dist_id_list,
3802: --bugfix:4674194
3803: SHIP_TO_LOCATION_ID,
3804: --bug7022001
3805: PAY_AWT_GROUP_ID
3806: FROM ap_invoice_lines_all
3807: WHERE invoice_id = X_invoice_id
3808: AND line_number = X_line_number;
3809:
3810:
3819: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
3820: l_assets_tracking_flag
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3823: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3824: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3825: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3826: user_id NUMBER;
3827: l_msg_application VARCHAR2(25);
3820: l_assets_tracking_flag
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3823: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3824: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3825: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3826: user_id NUMBER;
3827: l_msg_application VARCHAR2(25);
3828: l_msg_type VARCHAR2(25);
3821: AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE;
3822: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
3823: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3824: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
3825: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
3826: user_id NUMBER;
3827: l_msg_application VARCHAR2(25);
3828: l_msg_type VARCHAR2(25);
3829: l_msg_token1 VARCHAR2(30);
4041: End;
4042:
4043: select WEB_PARAMETER_ID
4044: into l_web_parameter_id
4045: from ap_invoice_lines
4046: where invoice_id = X_invoice_id
4047: AND line_number = X_line_number;
4048:
4049: /* Bug 5102724 */
4703: ----------------------------------------------------------------------------
4704: debug_info := 'Setting generate distributions flag to Done';
4705: IF (l_distribution_class = 'PERMANENT') then
4706: BEGIN
4707: UPDATE AP_INVOICE_LINES
4708: SET GENERATE_DISTS = 'D'
4709: WHERE invoice_id = X_invoice_id
4710: AND line_number = l_invoice_line_rec.line_number;
4711: EXCEPTION
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,
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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%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,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
4761: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
4754: X_chrg_line_project_id IN AP_INVOICE_LINES.PROJECT_ID%TYPE,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
4761: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
4762: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
4755: X_chrg_line_task_id IN AP_INVOICE_LINES.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
4761: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
4762: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
4763: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
4756: X_chrg_line_award_id IN AP_INVOICE_LINES.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
4761: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
4762: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
4763: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
4764: X_item_dist_award_id IN AP_INVOICE_DISTRIBUTIONS.award_ID%TYPE,
4757: X_chrg_line_expenditure_type IN AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE,
4758: X_chrg_line_exp_org_id IN AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE,
4759: X_chrg_assets_track_flag IN AP_INVOICE_LINES.ASSETS_TRACKING_FLAG%TYPE,
4760: X_chrg_asset_book_type_code IN AP_INVOICE_LINES.ASSET_BOOK_TYPE_CODE%TYPE,
4761: X_chrg_asset_category_id IN AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE,
4762: X_item_dist_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
4763: X_item_dist_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
4764: X_item_dist_award_id IN AP_INVOICE_DISTRIBUTIONS.award_ID%TYPE,
4765: X_item_dist_expenditure_type IN AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
4767: X_item_assets_track_flag IN AP_INVOICE_DISTRIBUTIONS.ASSETS_TRACKING_FLAG%TYPE,
4768: X_item_asset_book_type_code IN AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE,
4769: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
4770: X_chrg_line_default_ccid IN NUMBER,
4771: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
4772: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
4773: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
4774: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
4775: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
4768: X_item_asset_book_type_code IN AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE,
4769: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
4770: X_chrg_line_default_ccid IN NUMBER,
4771: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
4772: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
4773: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
4774: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
4775: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
4776: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,
4769: X_item_asset_category_id IN AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
4770: X_chrg_line_default_ccid IN NUMBER,
4771: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
4772: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
4773: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
4774: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
4775: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
4776: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,
4777: X_item_rcv_trx_id IN AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE,
4770: X_chrg_line_default_ccid IN NUMBER,
4771: X_overlay_dist_code_concat IN AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE,
4772: X_balancing_segment IN AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE,
4773: X_account_segment IN AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE,
4774: X_cost_center_segment IN AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE,
4775: X_item_dist_ccid IN AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE,
4776: X_item_po_dist_id IN AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE,
4777: X_item_rcv_trx_id IN AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE,
4778: X_pa_allows_overrides IN VARCHAR2,
4778: X_pa_allows_overrides IN VARCHAR2,
4779: X_allow_po_override IN VARCHAR2,
4780: X_project_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
4781: X_task_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
4782: X_award_id OUT NOCOPY AP_INVOICE_LINES.award_ID%TYPE,
4783: X_expenditure_type OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
4784: X_expenditure_org_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
4785: X_expenditure_item_date OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
4786: X_pa_addition_flag OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.PA_ADDITION_FLAG%TYPE,
4790: X_asset_category_id OUT NOCOPY AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE,
4791: X_error_code OUT NOCOPY VARCHAR2,
4792: X_msg_application OUT NOCOPY VARCHAR2,
4793: X_msg_data OUT NOCOPY VARCHAR2,
4794: X_default_dist_ccid IN AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE) --bug 5386396
4795: RETURN BOOLEAN
4796: IS
4797:
4798: l_po_accrue_on_receipt_flag PO_DISTRIBUTIONS.ACCRUE_ON_RECEIPT_FLAG%TYPE;
4900: End;
4901:
4902: select WEB_PARAMETER_ID
4903: into l_web_parameter_id
4904: from ap_invoice_lines
4905: where invoice_id = X_invoice_id
4906: AND line_number = X_line_number;
4907:
4908: /* Bug 5102724 */
5289: CURSOR applicable_lines_cur IS
5290: SELECT AIL.line_number,
5291: AIL.amount,
5292: sum(AID.amount)
5293: FROM AP_invoice_lines AIL,
5294: AP_invoice_distributions_all AID
5295: WHERE AIL.invoice_id = X_invoice_id
5296: AND nvl(AIL.discarded_flag, 'N') = 'N'
5297: AND nvl(AIL.cancelled_flag, 'N') = 'N'
5331:
5332:
5333: l_batch_id AP_INVOICE_DISTRIBUTIONS.BATCH_ID%TYPE;
5334: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5335: l_org_id AP_INVOICE_LINES.ORG_ID%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;
5332:
5333: l_batch_id AP_INVOICE_DISTRIBUTIONS.BATCH_ID%TYPE;
5334: l_distribution_class AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
5335: l_org_id AP_INVOICE_LINES.ORG_ID%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;
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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%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;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5349: l_asset_category_id AP_INVOICE_LINES.ASSET_CATEGORY_ID%TYPE;
5350: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5350: l_line_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5351: l_line_base_amount AP_INVOICE_LINES.BASE_AMOUNT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5352: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5353: l_line_description AP_INVOICE_LINES.DESCRIPTION%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5354: l_sum_lines_amount AP_INVOICE_LINES.AMOUNT%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5355: l_default_dist_ccid AP_INVOICE_LINES.DEFAULT_DIST_CCID%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5356: l_overlay_dist_concat AP_INVOICE_LINES.OVERLAY_DIST_CODE_CONCAT%TYPE;
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5357: l_balancing_segment AP_INVOICE_LINES.BALANCING_SEGMENT%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5358: l_account_segment AP_INVOICE_LINES.ACCOUNT_SEGMENT%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5359: l_cost_center_segment AP_INVOICE_LINES.COST_CENTER_SEGMENT%TYPE;
5360: l_project_id AP_INVOICE_LINES.PROJECT_ID%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5361: l_task_id AP_INVOICE_LINES.TASK_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5362: l_award_id AP_INVOICE_LINES.AWARD_ID%TYPE;
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5363: l_expenditure_type AP_INVOICE_LINES.EXPENDITURE_TYPE%TYPE;
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5364: l_expenditure_organization_id
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5365: AP_INVOICE_LINES.EXPENDITURE_ORGANIZATION_ID%TYPE;
5366: l_accounting_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5367: l_created_by AP_INVOICE_LINES.CREATED_BY%TYPE;
5368: l_last_update_login AP_INVOICE_LINES.LAST_UPDATE_LOGIN%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5374: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
5375: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5369: l_awt_group_id AP_INVOICE_LINES.AWT_GROUP_ID%TYPE;
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5374: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
5375: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5376: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5377: l_invoice_distribution_id
5370:
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5374: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
5375: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5376: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5377: l_invoice_distribution_id
5378: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
5371: l_pay_awt_group_id AP_INVOICE_LINES.PAY_AWT_GROUP_ID%TYPE; ---7022001
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5374: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
5375: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5376: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5377: l_invoice_distribution_id
5378: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
5379: l_po_distribution_id AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
5372:
5373: l_type_1099 AP_INVOICE_LINES.TYPE_1099%TYPE;
5374: l_income_tax_region AP_INVOICE_LINES.INCOME_TAX_REGION%TYPE;
5375: l_open_gl_date AP_INVOICE_LINES.ACCOUNTING_DATE%TYPE;
5376: l_open_period_name AP_INVOICE_LINES.PERIOD_NAME%TYPE;
5377: l_invoice_distribution_id
5378: AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
5379: l_po_distribution_id AP_INVOICE_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
5380: l_rcv_transaction_id AP_INVOICE_DISTRIBUTIONS.RCV_TRANSACTION_ID%TYPE;
5395: AP_INVOICE_DISTRIBUTIONS.ASSET_BOOK_TYPE_CODE%TYPE;
5396: l_dist_asset_category_id
5397: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
5398: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
5399: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5396: l_dist_asset_category_id
5397: AP_INVOICE_DISTRIBUTIONS.ASSET_CATEGORY_ID%TYPE;
5398: l_dist_description AP_INVOICE_DISTRIBUTIONS.DESCRIPTION%TYPE;
5399: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5413: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5413: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5414: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5415: l_msg_application VARCHAR2(25);
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5413: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5414: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5415: l_msg_application VARCHAR2(25);
5416: l_msg_data VARCHAR2(30);
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5413: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5414: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5415: l_msg_application VARCHAR2(25);
5416: l_msg_data VARCHAR2(30);
5417: i BINARY_INTEGER := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
5411: l_running_total_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5412: l_running_total_base_amt AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5413: l_max_alloc AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5414: l_max_base_alloc AP_INVOICE_LINES.BASE_AMOUNT%TYPE := 0;
5415: l_msg_application VARCHAR2(25);
5416: l_msg_data VARCHAR2(30);
5417: i BINARY_INTEGER := 0;
5418: t BINARY_INTEGER := 0;
5432: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
5433:
5434: -- Bug 5114543
5435: l_max_dist_line_num NUMBER :=0;
5436: l_chrg_line_rec ap_invoice_lines_all%rowtype;
5437: l_dummy VARCHAR2(30);
5438:
5439: BEGIN
5440:
5502: l_income_tax_region,
5503: l_created_by,
5504: l_last_update_login,
5505: l_pay_awt_group_id
5506: FROM ap_invoice_lines
5507: WHERE invoice_id = X_invoice_id
5508: AND line_number = X_line_number;
5509:
5510: EXCEPTION
5536: -- continue with creation of charge distributions based on the allocation.
5537:
5538: select ail.*
5539: into l_chrg_line_rec
5540: from ap_invoice_lines_all ail
5541: where invoice_id = X_invoice_id
5542: and line_number = X_line_number;
5543:
5544: if not ap_invoice_lines_pkg.reverse_charge_distributions
5540: from ap_invoice_lines_all ail
5541: where invoice_id = X_invoice_id
5542: and line_number = X_line_number;
5543:
5544: if not ap_invoice_lines_pkg.reverse_charge_distributions
5545: (p_inv_line_rec => l_chrg_line_rec
5546: ,p_calling_mode => l_dummy
5547: ,x_error_code => x_error_code
5548: ,x_debug_info => debug_info
5621: SELECT DECODE(NVL(ai.net_of_retainage_flag, 'N'),
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')
5658:
5659: BEGIN
5660: SELECT count(*)
5661: INTO l_count_undistributed_lines
5662: FROM ap_invoice_lines_all AIL
5663: WHERE AIL.invoice_id = X_invoice_id
5664: AND AIL.line_type_lookup_code = 'ITEM'
5665: AND NVL(AIL.match_type,'NOT_MATCHED') NOT IN
5666: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')
5689: BEGIN
5690:
5691: SELECT count(*)
5692: INTO l_count_undistributed_lines
5693: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL
5694: WHERE AIL.invoice_id = X_invoice_id
5695: AND ARL.invoice_id = X_invoice_id
5696: AND ARL.chrg_invoice_line_number = X_line_number
5697: AND ARL.to_invoice_line_number = AIL.line_number
5963: l_max_base_alloc := 0;
5964: l_running_total_base_amt := 0;
5965:
5966: -- Bug 5114543
5967: l_max_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num
5968: (x_invoice_id, x_line_number) + 1;
5969:
5970: FOR t IN 0..l_alloc_line_tab.COUNT-1 LOOP
5971: l_running_total_alloc := 0;
6490: --ETAX: Invwkb
6491: ail.primary_intended_use, -- intended_use
6492: 'N', -- rcv_charge_addition_flag
6493: l_pay_awt_group_id -- pay_awt_group_id 7022001
6494: FROM ap_invoice_lines AIL, --Charge line
6495: ap_invoice_lines AIL1, --ITEM Line
6496: ap_invoice_distributions aid
6497: WHERE ail.invoice_id = X_invoice_id
6498: AND ail.line_number = X_line_number
6491: ail.primary_intended_use, -- intended_use
6492: 'N', -- rcv_charge_addition_flag
6493: l_pay_awt_group_id -- pay_awt_group_id 7022001
6494: FROM ap_invoice_lines AIL, --Charge line
6495: ap_invoice_lines AIL1, --ITEM Line
6496: ap_invoice_distributions aid
6497: WHERE ail.invoice_id = X_invoice_id
6498: AND ail.line_number = X_line_number
6499: AND aid.invoice_id = ail.invoice_id
6524: -- generate_dists on the charge line should be set to 'Done'
6525: -- when the line amount equals the distributions total.
6526:
6527: BEGIN
6528: UPDATE AP_INVOICE_LINES
6529: SET GENERATE_DISTS = 'D'
6530: WHERE invoice_id = X_invoice_id
6531: AND line_number = X_line_number
6532: AND amount = (select sum(amount)
6558: WHERE invoice_id = X_invoice_id
6559: AND chrg_invoice_line_number = X_line_number
6560: AND exists
6561: (select 'Line Amount Equals Distribution Total'
6562: from ap_invoice_lines_all ail,
6563: ap_invoice_distributions_all aid
6564: where ail.invoice_id = aid.invoice_id
6565: and ail.line_number = aid.invoice_line_number
6566: and ail.invoice_id = X_invoice_id
7272: (P_Invoice_Id IN NUMBER,
7273: P_Invoice_Line_Number IN NUMBER DEFAULT NULL,
7274: P_Calling_Sequence IN VARCHAR2) IS
7275:
7276: TYPE INVOICE_LINE_NUMBER_LIST IS TABLE OF ap_invoice_lines.line_number%TYPE;
7277: l_line_number_tab INVOICE_LINE_NUMBER_LIST;
7278: l_debug_info VARCHAR2(2000);
7279: current_calling_sequence VARCHAR2(2000);
7280: l_line_number NUMBER;
7301: WHERE invoice_id = p_invoice_id
7302: AND invoice_line_number = NVL(p_invoice_line_number, invoice_line_number)
7303: AND distribution_class = 'CANDIDATE';
7304:
7305: l_debug_info := 'Updating ap_invoice_lines';
7306:
7307: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
7308:
7309: l_line_number := l_line_number_tab(uniq_values);
7307: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
7308:
7309: l_line_number := l_line_number_tab(uniq_values);
7310:
7311: UPDATE ap_invoice_lines_all ail
7312: SET generate_dists = 'D'
7313: WHERE nvl(ail.generate_dists,'N') = 'Y'
7314: AND invoice_id = p_invoice_id
7315: AND ail.line_number = l_line_number_tab(uniq_values);
7325: SET STATUS = 'EXECUTED'
7326: WHERE alr.invoice_id = p_invoice_id
7327: AND alr.chrg_invoice_line_number = l_line_number_tab(uniq_values)
7328: AND EXISTS (SELECT 'Valid charge line'
7329: FROM ap_invoice_lines ail
7330: WHERE ail.invoice_id = p_invoice_id --bug 5052657
7331: AND ail.line_number = alr.chrg_invoice_line_number
7332: AND nvl(ail.generate_dists,'N') = 'D'
7333: AND ail.line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS'));