[Home] [Help]
1: PACKAGE BODY AP_WEB_DB_AP_INT_PKG AS
2: /* $Header: apwdbapb.pls 120.38.12010000.3 2008/08/13 07:17:48 rveliche ship $ */
3:
4: /* -------------------------------------------------------------------
5: -- Function to get from ap_system_parameters:
73: l_set_of_books_id apSetup_setOfBooksID;
74: l_expense_report_id apSetup_expenseReportID;
75: l_default_exch_rate_type apSetUp_defaultExchRateType;
76: BEGIN
77: return AP_WEB_DB_AP_INT_PKG.get_ap_system_params(p_base_curr_code => p_base_curr_code,
78: p_set_of_books_id => l_set_of_books_id,
79: p_expense_report_id => l_expense_report_id,
80: p_default_exch_rate_type => l_default_exch_rate_type);
81:
99: l_expense_report_id apSetup_expenseReportID;
100: l_default_exch_rate_type apSetUp_defaultExchRateType;
101:
102: BEGIN
103: return AP_WEB_DB_AP_INT_PKG.get_ap_system_params(p_base_curr_code => l_base_curr_code,
104: p_set_of_books_id => p_set_of_books_id,
105: p_expense_report_id => l_expense_report_id,
106: p_default_exch_rate_type => l_default_exch_rate_type);
107:
626: --------------------------------------------------------------------------------
627: l_valid VARCHAR2(1) := 'N';
628:
629: l_employee_id number;
630: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
631: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
632:
633: /*Bug 2690715 : variable declarations */
634:
634:
635:
636: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
637:
638: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
639: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
640: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
641:
642: /*Bug 2699258:Added proper join conditions between S,GS,HR
635:
636: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
637:
638: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
639: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
640: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
641:
642: /*Bug 2699258:Added proper join conditions between S,GS,HR
643: so that Merge Join Cartesians.
636: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
637:
638: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
639: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
640: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
641:
642: /*Bug 2699258:Added proper join conditions between S,GS,HR
643: so that Merge Join Cartesians.
644: */
682: WHERE emp.person_id = l_employee_id
683: );
684:
685: -- Get the chart_of_account_id from system parameters
686: IF (NOT AP_WEB_DB_AP_INT_PKG.GetCOAofSOB(l_ou_chart_of_accounts_id)) THEN
687: l_ou_chart_of_accounts_id := null;
688: END IF;
689:
690: IF (l_emp_set_of_books_id is not null) THEN
1136:
1137: EXCEPTION
1138:
1139: WHEN OTHERS THEN
1140: AP_WEB_DB_UTIL_PKG.RaiseException( 'AP_WEB_DB_AP_INT_PKG.GenTaxFunctions' );
1141: APP_EXCEPTION.RAISE_EXCEPTION;
1142:
1143: END GenTaxFunctions;
1144:
1378: WHERE card.card_program_id = txn.card_program_id
1379: AND card.card_id = txn.card_id
1380: AND txn.trx_id = p_trx_id;
1381:
1382: IF NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_ccid,
1383: p_card_program_id => l_card_program_id,
1384: p_employee_id => l_employee_id,
1385: p_as_of_date => l_transaction_date) THEN
1386: l_ccid := null;
1398:
1399: -------------------------------------------------------------------
1400:
1401:
1402: END AP_WEB_DB_AP_INT_PKG;