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.IEX_UWQ_VIEW_PKG dependencies on FND_PROFILE

Line 37: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');

33: l_enable_bkr_filter VARCHAR2(40);
34: l_Complete_Days varchar2(40);
35:
36: BEGIN
37: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
38: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
39:
40: IF p_party_id > 0 THEN
41: l_del_clause := 'SELECT COUNT(1) FROM iex_delinquencies WHERE party_cust_id = :party_id ' ||

Line 38: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

34: l_Complete_Days varchar2(40);
35:
36: BEGIN
37: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
38: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
39:
40: IF p_party_id > 0 THEN
41: l_del_clause := 'SELECT COUNT(1) FROM iex_delinquencies WHERE party_cust_id = :party_id ' ||
42: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-exclude CLOSE status

Line 126: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');

122: l_bnkrpt_cnt NUMBER := 0;
123: l_enable_bkr_filter VARCHAR2(40);
124: l_Complete_Days varchar2(40);
125: BEGIN
126: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
127: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
128:
129: IF p_party_id > 0 THEN
130: l_pro_clause := 'SELECT COUNT(1) ' ||

Line 127: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

123: l_enable_bkr_filter VARCHAR2(40);
124: l_Complete_Days varchar2(40);
125: BEGIN
126: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
127: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
128:
129: IF p_party_id > 0 THEN
130: l_pro_clause := 'SELECT COUNT(1) ' ||
131: 'FROM (' ||

Line 316: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');

312: l_bnkrpt_cnt NUMBER := 0;
313: l_Complete_Days varchar2(40);
314: l_enable_bkr_filter VARCHAR2(40);
315: BEGIN
316: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
317: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
318:
319: IF p_party_id > 0 THEN
320: l_str_clause := 'SELECT COUNT(1) FROM iex_strategy_work_items wtm, iex_strategies str ' ||

Line 317: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

313: l_Complete_Days varchar2(40);
314: l_enable_bkr_filter VARCHAR2(40);
315: BEGIN
316: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');
317: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
318:
319: IF p_party_id > 0 THEN
320: l_str_clause := 'SELECT COUNT(1) FROM iex_strategy_work_items wtm, iex_strategies str ' ||
321: 'WHERE wtm.strategy_id = str.strategy_id ' ||

Line 824: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

820: l_Complete_Days varchar2(40);
821: l_lease_enabled VARCHAR2(40);
822: BEGIN
823: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
824: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
825: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
826: --
827: -- IF l_lease_enabled = 'N' THEN
828: -- return 0;

Line 825: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');

821: l_lease_enabled VARCHAR2(40);
822: BEGIN
823: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
824: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
825: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
826: --
827: -- IF l_lease_enabled = 'N' THEN
828: -- return 0;
829: -- END IF;

Line 923: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

919: l_Complete_Days varchar2(40);
920: l_lease_enabled VARCHAR2(40);
921: BEGIN
922: --Begin-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
923: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
924: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
925: --
926: -- IF l_lease_enabled = 'N' THEN
927: -- return 0;

Line 924: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');

920: l_lease_enabled VARCHAR2(40);
921: BEGIN
922: --Begin-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
923: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
924: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
925: --
926: -- IF l_lease_enabled = 'N' THEN
927: -- return 0;
928: -- END IF;

Line 1011: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

1007: END get_case_count;
1008:
1009: BEGIN
1010:
1011: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1012: g_user_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('USER_ID'), -1));
1013:
1014: OPEN c_get_emp(g_user_id);
1015: FETCH c_get_emp INTO g_person_id;

Line 1012: g_user_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('USER_ID'), -1));

1008:
1009: BEGIN
1010:
1011: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1012: g_user_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('USER_ID'), -1));
1013:
1014: OPEN c_get_emp(g_user_id);
1015: FETCH c_get_emp INTO g_person_id;
1016: CLOSE c_get_emp;