APPS.IEX_UTILITIES dependencies on IEX_UTILITIES

Line 1: PACKAGE BODY IEX_UTILITIES AS

1: PACKAGE BODY IEX_UTILITIES AS
2: /* $Header: iexvutlb.pls 120.61.12020000.7 2013/02/20 19:51:21 ehuh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_UTILITIES';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvutlb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_UTILITIES';

1: PACKAGE BODY IEX_UTILITIES AS
2: /* $Header: iexvutlb.pls 120.61.12020000.7 2013/02/20 19:51:21 ehuh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_UTILITIES';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvutlb.pls';
6: G_APPL_ID NUMBER;
7: G_LOGIN_ID NUMBER;
8: G_PROGRAM_ID NUMBER;

Line 1225: function buildWhereClause(P_CONDITIONS IN IEX_UTILITIES.Condition_TBL) return VARCHAR2

1221: ||
1222: || Major Modifications: when who what
1223: || 01/28/2003 5:53PM raverma created
1224: */
1225: function buildWhereClause(P_CONDITIONS IN IEX_UTILITIES.Condition_TBL) return VARCHAR2
1226: IS
1227:
1228: l_conditions IEX_UTILITIES.Condition_TBL;
1229: l_return VARCHAR2(5000);

Line 1228: l_conditions IEX_UTILITIES.Condition_TBL;

1224: */
1225: function buildWhereClause(P_CONDITIONS IN IEX_UTILITIES.Condition_TBL) return VARCHAR2
1226: IS
1227:
1228: l_conditions IEX_UTILITIES.Condition_TBL;
1229: l_return VARCHAR2(5000);
1230: l_count NUMBER := 0;
1231:
1232: --clchang updated for sql bind var 05/07/2003

Line 3698: -- l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;

3694: i number := 0;
3695: l_stage number;
3696: l_api_name varchar2(100);
3697:
3698: -- l_inc_inv_curr IEX_UTILITIES.INC_INV_CURR_TBL;
3699:
3700: cursor c_bill_dunning_trx_null_dun_ct (p_site_use_id number, p_min_days_bw_dun number,
3701: p_corr_date date, p_grace_days number, p_include_dis_items varchar,
3702: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is

Line 4113: l_api_name := 'IEX_UTILITIES.StagedDunningMinAmountCheck';

4109: WriteLog('p_org_id : '||p_org_id);
4110:
4111: l_inc_inv_curr.delete;
4112:
4113: l_api_name := 'IEX_UTILITIES.StagedDunningMinAmountCheck';
4114:
4115: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
4116: --Begin Bug 10401991 14-Feb-2011 barathsr
4117: l_billto_tot_acctd_amt_rem:=0;

Line 5807: END IEX_UTILITIES;

5803: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
5804:
5805: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5806:
5807: END IEX_UTILITIES;