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 318: l_enable_bkr_filter := NVL(FND_PROFILE.VALUE('IEX_BANKRUPTCY_FILTER'), 'Y');

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

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

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

Line 420: l_conversion_type := NVL(FND_PROFILE.VALUE('IEX_EXCHANGE_RATE_TYPE'), 'Corporate');

416:
417: /* OPEN c_rate_type;
418: FETCH c_rate_type INTO l_conversion_type;
419: CLOSE c_rate_type; */
420: l_conversion_type := NVL(FND_PROFILE.VALUE('IEX_EXCHANGE_RATE_TYPE'), 'Corporate');
421: l_to_amount := gl_currency_api.convert_amount(x_set_of_books_id => l_set_of_books_id,
422: x_from_currency => p_from_currency,
423: x_conversion_date => sysdate,
424: x_conversion_type => l_conversion_type,

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

791: l_Complete_Days varchar2(40);
792: l_lease_enabled VARCHAR2(40);
793: BEGIN
794: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
795: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
796: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
797: --
798: -- IF l_lease_enabled = 'N' THEN
799: -- return 0;

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

792: l_lease_enabled VARCHAR2(40);
793: BEGIN
794: --BEGIN-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
795: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
796: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
797: --
798: -- IF l_lease_enabled = 'N' THEN
799: -- return 0;
800: -- END IF;

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

890: l_Complete_Days varchar2(40);
891: l_lease_enabled VARCHAR2(40);
892: BEGIN
893: --Begin-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
894: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
895: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
896: --
897: -- IF l_lease_enabled = 'N' THEN
898: -- return 0;

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

891: l_lease_enabled VARCHAR2(40);
892: BEGIN
893: --Begin-FIX Bug#4408860-06/06/2005-jypark-obsolete function because we're not showing this field in UWQ
894: -- l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
895: -- l_lease_enabled := NVL(FND_PROFILE.VALUE('IEX_LEASE_ENABLED'), 'N');
896: --
897: -- IF l_lease_enabled = 'N' THEN
898: -- return 0;
899: -- END IF;

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

978: END get_case_count;
979:
980: BEGIN
981:
982: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
983: g_user_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('USER_ID'), -1));
984:
985: OPEN c_get_emp(g_user_id);
986: FETCH c_get_emp INTO g_person_id;

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

979:
980: BEGIN
981:
982: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
983: g_user_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('USER_ID'), -1));
984:
985: OPEN c_get_emp(g_user_id);
986: FETCH c_get_emp INTO g_person_id;
987: CLOSE c_get_emp;