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

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_WEB_DB_AP_INT_PKG

Line 1: PACKAGE BODY AP_WEB_DB_AP_INT_PKG AS

1: PACKAGE BODY AP_WEB_DB_AP_INT_PKG AS
2: /* $Header: apwdbapb.pls 120.51.12020000.2 2012/07/05 14:12:36 rveliche ship $ */
3:
4: /* -------------------------------------------------------------------
5: -- Function to get from ap_system_parameters:

Line 77: return AP_WEB_DB_AP_INT_PKG.get_ap_system_params(p_base_curr_code => p_base_curr_code,

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:

Line 103: return AP_WEB_DB_AP_INT_PKG.get_ap_system_params(p_base_curr_code => l_base_curr_code,

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:

Line 152: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_default_exch_rate_type);

148: -------------------------------------------------------------------
149: l_default_exch_rate_type apSetUp_defaultExchRateType;
150:
151: BEGIN
152: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange(l_default_exch_rate_type);
153:
154: SELECT s.base_currency_code,
155: l_default_exch_rate_type,
156: c.name,

Line 653: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

649: --------------------------------------------------------------------------------
650: l_valid VARCHAR2(1) := 'N';
651:
652: l_employee_id number;
653: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
654: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
655:
656: /*Bug 2690715 : variable declarations */
657:

Line 661: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;

657:
658:
659: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
660:
661: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
662: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
663: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
664:
665: /*Bug 2699258:Added proper join conditions between S,GS,HR

Line 662: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

658:
659: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
660:
661: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
662: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
663: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
664:
665: /*Bug 2699258:Added proper join conditions between S,GS,HR
666: so that Merge Join Cartesians.

Line 663: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;

659: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
660:
661: l_emp_set_of_books_id AP_WEB_DB_AP_INT_PKG.glsob_setOfBooksID;
662: l_ou_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
663: l_emp_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
664:
665: /*Bug 2699258:Added proper join conditions between S,GS,HR
666: so that Merge Join Cartesians.
667: */

Line 709: IF (NOT AP_WEB_DB_AP_INT_PKG.GetCOAofSOB(l_ou_chart_of_accounts_id)) THEN

705: WHERE emp.person_id = l_employee_id
706: );
707:
708: -- Get the chart_of_account_id from system parameters
709: IF (NOT AP_WEB_DB_AP_INT_PKG.GetCOAofSOB(l_ou_chart_of_accounts_id)) THEN
710: l_ou_chart_of_accounts_id := null;
711: END IF;
712:
713: IF (l_emp_set_of_books_id is not null) THEN

Line 1182: AP_WEB_DB_UTIL_PKG.RaiseException( 'AP_WEB_DB_AP_INT_PKG.GenTaxFunctions' );

1178:
1179: EXCEPTION
1180:
1181: WHEN OTHERS THEN
1182: AP_WEB_DB_UTIL_PKG.RaiseException( 'AP_WEB_DB_AP_INT_PKG.GenTaxFunctions' );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184:
1185: END GenTaxFunctions;
1186:

Line 1424: IF NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_ccid,

1420: WHERE card.card_program_id = txn.card_program_id
1421: AND card.card_id = txn.card_id
1422: AND txn.trx_id = p_trx_id;
1423:
1424: IF NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_ccid,
1425: p_card_program_id => l_card_program_id,
1426: p_employee_id => l_employee_id,
1427: p_as_of_date => l_transaction_date) THEN
1428: l_ccid := null;

Line 1495: END AP_WEB_DB_AP_INT_PKG;

1491:
1492: -------------------------------------------------------------------------------------
1493:
1494:
1495: END AP_WEB_DB_AP_INT_PKG;