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.
[Home] [Help]
APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_UTILITIES
Line 2424: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
2420:
2421: CURSOR c_str_levels IS
2422: SELECT lookup_code FROM IEX_LOOKUPS_V
2423: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
2424: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
2425:
2426: CURSOR c_system_str_level(p_org_id number) IS
2427: select preference_value
2428: from iex_app_preferences_b
Line 3393: SELECT iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',preference_value)
3389: from iex_questionnaire_items;
3390:
3391: cursor c_system_str_level
3392: is
3393: SELECT iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',preference_value)
3394: FROM iex_app_preferences_b
3395: WHERE preference_name='COLLECTIONS STRATEGY LEVEL'
3396: AND enabled_flag = 'Y'
3397: AND org_id IS NULL;
Line 3516: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_cust) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3512: l_xml_header := l_xml_header ||l_new_line||'';
3513: l_xml_header := l_xml_header ||l_new_line||' '||l_report_date||' ';
3514: l_xml_header := l_xml_header ||l_new_line||' '|| l_strategy_level_name ||' ';
3515: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_cust ||' ';
3516: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_cust) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3517: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_acc ||' ';
3518: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_acc)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3519: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_billto ||' ';
3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
Line 3518: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_acc)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3514: l_xml_header := l_xml_header ||l_new_line||' '|| l_strategy_level_name ||' ';
3515: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_cust ||' ';
3516: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_cust) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3517: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_acc ||' ';
3518: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_acc)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3519: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_billto ||' ';
3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3521: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_del ||' ';
3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
Line 3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3516: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_cust) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3517: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_acc ||' ';
3518: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_acc)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3519: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_billto ||' ';
3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3521: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_del ||' ';
3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3523: l_xml_header := l_xml_header ||l_new_line||' '|| l_org_override_patry ||' ';
3524: l_xml_header := l_xml_header ||l_new_line||' '||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_org_override_patry) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
Line 3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3518: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_acc)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3519: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_billto ||' ';
3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3521: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_del ||' ';
3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3523: l_xml_header := l_xml_header ||l_new_line||' '|| l_org_override_patry ||' ';
3524: l_xml_header := l_xml_header ||l_new_line||' '||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_org_override_patry) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3525: l_xml_header := l_xml_header ||l_new_line||' '|| l_coll_at_ous ||' ';
3526: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_coll_at_ous) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
Line 3524: l_xml_header := l_xml_header ||l_new_line||' '||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_org_override_patry) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3520: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_billto)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3521: l_xml_header := l_xml_header ||l_new_line||' '|| l_process_sty_by_del ||' ';
3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3523: l_xml_header := l_xml_header ||l_new_line||' '|| l_org_override_patry ||' ';
3524: l_xml_header := l_xml_header ||l_new_line||' '||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_org_override_patry) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3525: l_xml_header := l_xml_header ||l_new_line||' '|| l_coll_at_ous ||' ';
3526: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_coll_at_ous) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3527: l_xml_header := l_xml_header ||l_new_line||' '|| l_terr_acc_level ||' ';
3528: l_xml_header := l_xml_header ||l_new_line||' ' || p_strategy_mode ||' ';
Line 3526: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_coll_at_ous) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3522: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_process_sty_by_del)||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3523: l_xml_header := l_xml_header ||l_new_line||' '|| l_org_override_patry ||' ';
3524: l_xml_header := l_xml_header ||l_new_line||' '||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_org_override_patry) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3525: l_xml_header := l_xml_header ||l_new_line||' '|| l_coll_at_ous ||' ';
3526: l_xml_header := l_xml_header ||l_new_line||' '|| iex_utilities.get_lookup_meaning('IEX_YES_NO',l_coll_at_ous) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3527: l_xml_header := l_xml_header ||l_new_line||' '|| l_terr_acc_level ||' ';
3528: l_xml_header := l_xml_header ||l_new_line||' ' || p_strategy_mode ||' ';
3529: l_xml_header := l_xml_header ||l_new_line||' ' || FND_GLOBAL.CONC_REQUEST_ID ||' ';
3530: l_xml_header := l_xml_header ||l_new_line||' ' || l_pro_sty_by_ou ||' ';
Line 3531: l_xml_header := l_xml_header ||l_new_line||' ' || iex_utilities.get_lookup_meaning('IEX_YES_NO',l_pro_sty_by_ou) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3527: l_xml_header := l_xml_header ||l_new_line||' '|| l_terr_acc_level ||' ';
3528: l_xml_header := l_xml_header ||l_new_line||' ' || p_strategy_mode ||' ';
3529: l_xml_header := l_xml_header ||l_new_line||' ' || FND_GLOBAL.CONC_REQUEST_ID ||' ';
3530: l_xml_header := l_xml_header ||l_new_line||' ' || l_pro_sty_by_ou ||' ';
3531: l_xml_header := l_xml_header ||l_new_line||' ' || iex_utilities.get_lookup_meaning('IEX_YES_NO',l_pro_sty_by_ou) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3532: l_xml_header := l_xml_header ||l_new_line||' ' || l_skip_def_sty_assign ||' ';
3533: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_skip_def_sty_assign) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3534: l_xml_header := l_xml_header ||l_new_line||' ' || format_string(l_DefaultTempName) ||' ';
3535: l_xml_header := l_xml_header ||l_new_line||' ' || format_string(l_SourceName) ||' ';
Line 3533: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_skip_def_sty_assign) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3529: l_xml_header := l_xml_header ||l_new_line||' ' || FND_GLOBAL.CONC_REQUEST_ID ||' ';
3530: l_xml_header := l_xml_header ||l_new_line||' ' || l_pro_sty_by_ou ||' ';
3531: l_xml_header := l_xml_header ||l_new_line||' ' || iex_utilities.get_lookup_meaning('IEX_YES_NO',l_pro_sty_by_ou) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3532: l_xml_header := l_xml_header ||l_new_line||' ' || l_skip_def_sty_assign ||' ';
3533: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_YES_NO',l_skip_def_sty_assign) ||' ';--Added for Bug 10037019 03-Sep-2010 barathsr
3534: l_xml_header := l_xml_header ||l_new_line||' ' || format_string(l_DefaultTempName) ||' ';
3535: l_xml_header := l_xml_header ||l_new_line||' ' || format_string(l_SourceName) ||' ';
3536: l_xml_header := l_xml_header ||l_new_line||' ' || l_fulfilment_rs ||' ';
3537: l_xml_header := l_xml_header ||l_new_line||' ' || l_grace_preiod ||' ';
Line 3607: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,
3603: sty.delinquency_id,
3604: sty.score_value,
3605: tpl.strategy_name,
3606: stry_temp_wkitem.name,
3607: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,
3608: jtf.source_name,
3609: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3610: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name,
3611: sty.strategy_level strategy_level
Line 3609: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3605: tpl.strategy_name,
3606: stry_temp_wkitem.name,
3607: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',swi.status_code) STATUS_MEANING,
3608: jtf.source_name,
3609: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3610: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name,
3611: sty.strategy_level strategy_level
3612: from iex_strategies sty,
3613: iex_strategy_templates_tl tpl,
Line 3634: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3630: sty.customer_site_use_id,
3631: sty.delinquency_id,
3632: sty.score_value,
3633: tpl.strategy_name,
3634: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3635: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name,
3636: sty.strategy_level strategy_level
3637: from iex_strategies sty,
3638: iex_strategy_templates_tl tpl
Line 3646: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(DECODE(p_strategy_rec.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3642:
3643: cursor c_strategy_name (l_sty_template_id number)
3644: is
3645: SELECT tpl.strategy_name,
3646: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(DECODE(p_strategy_rec.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3647: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name
3648: FROM iex_strategy_templates_tl tpl,
3649: iex_strategy_templates_b tpb
3650: WHERE tpb.strategy_temp_id = tpl.strategy_temp_id
Line 3659: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING
3655: cursor c_first_work_item (l_sty_template_id number)
3656: is
3657: select stry_temp_wkitem.name,
3658: stry_temp_wkitem.work_item_temp_id,
3659: iex_utilities.get_lookup_meaning('IEX_STRATEGY_WORK_STATUS',(decode(stry_temp_wkitem.pre_execution_wait,0,'OPEN','PRE-WAIT'))) STATUS_MEANING
3660: from iex_strategy_work_temp_xref xref
3661: ,iex_stry_temp_work_items_vl stry_temp_wkitem
3662: where xref.work_item_temp_id = stry_temp_wkitem.work_item_temp_id
3663: and xref.strategy_temp_id = l_sty_template_id