DBA Data[Home] [Help]

APPS.WF_EVENT_HTML dependencies on WF_LOV

Line 2471: REPLACE('wf_lov.display_lov?p_lov_name='||'h_master_guid'||

2467: -- add LOV here:
2468: -- Note: The REPLACE function replaces all the space characters with
2469: -- the proper escape sequence.
2470: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2471: REPLACE('wf_lov.display_lov?p_lov_name='||'h_master_guid'||
2472: '&p_display_name='||'SYSTEM'||
2473: '&p_validation_callback=wf_event_html.wf_system_val'||
2474: '&p_dest_hidden_field=top.opener.parent.document.WF_SYSTEM_EDIT.h_master_guid.value'||
2475: '&p_current_value=top.opener.parent.document.WF_SYSTEM_EDIT.display_master.value'||

Line 2779: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||

2775: -- add LOV here:
2776: -- Note: The REPLACE function replaces all the space characters with
2777: -- the proper escape sequence.
2778: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2779: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||
2780: '&p_display_name='||'SYSTEM'||
2781: '&p_validation_callback=wf_event_html.wf_system_val'||
2782: '&p_dest_hidden_field=top.opener.parent.document.WF_AGENT_EDIT.h_system_guid.value'||
2783: '&p_current_value=top.opener.parent.document.WF_AGENT_EDIT.display_system.value'||

Line 3318: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||

3314: -- add LOV here:
3315: -- Note: The REPLACE function replaces all the space characters with
3316: -- the proper escape sequence.
3317: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3318: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||
3319: '&p_display_name='||'SYSTEM'||
3320: '&p_validation_callback=wf_event_html.wf_system_val'||
3321: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_system_guid.value'||
3322: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_system.value'||

Line 3376: REPLACE('wf_lov.display_lov?p_lov_name='||'h_event_guid'||

3372: -- add LOV here:
3373: -- Note: The REPLACE function replaces all the space characters with
3374: -- the proper escape sequence.
3375: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3376: REPLACE('wf_lov.display_lov?p_lov_name='||'h_event_guid'||
3377: '&p_display_name='||'WFE_FIND_EVENT'||
3378: '&p_validation_callback=wf_event_html.wf_event_val'||
3379: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_event_guid.value'||
3380: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_event.value'||

Line 3407: REPLACE('wf_lov.display_lov?p_lov_name='||'h_source_agent_guid'||

3403: -- add LOV here:
3404: -- Note: The REPLACE function replaces all the space characters with
3405: -- the proper escape sequence.
3406: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3407: REPLACE('wf_lov.display_lov?p_lov_name='||'h_source_agent_guid'||
3408: '&p_display_name='||'WFE_FIND_AGENT'||
3409: '&p_validation_callback=wf_event_html.wf_agent_val'||
3410: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_source_agent_guid.value'||
3411: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_source_agent.value'||

Line 3508: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfptype_dname'||

3504: -- add LOV here:
3505: -- Note: The REPLACE function replaces all the space characters with
3506: -- the proper escape sequence.
3507: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3508: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfptype_dname'||
3509: '&p_display_name='||'ITEMTYPE'||
3510: '&p_validation_callback=wf_event_html.wf_itemtype_val'||
3511: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype_dname.value'||
3512: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype.value'||

Line 3539: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfpname'||

3535: -- add LOV here:
3536: -- Note: The REPLACE function replaces all the space characters with
3537: -- the proper escape sequence.
3538: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3539: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfpname'||
3540: '&p_display_name='||'PROCESS'||
3541: '&p_validation_callback=wf_event_html.wf_processname_val'||
3542: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptn.value'||
3543: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.h_wfpname.value'||

Line 3572: REPLACE('wf_lov.display_lov?p_lov_name='||'h_out_agent_guid'||

3568: -- add LOV here:
3569: -- Note: The REPLACE function replaces all the space characters with
3570: -- the proper escape sequence.
3571: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3572: REPLACE('wf_lov.display_lov?p_lov_name='||'h_out_agent_guid'||
3573: '&p_display_name='||'AGENT'||
3574: '&p_validation_callback=wf_event_html.wf_agent_val'||
3575: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_out_agent_guid.value'||
3576: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_out_agent.value'||

Line 3606: REPLACE('wf_lov.display_lov?p_lov_name='||'h_to_agent_guid'||

3602: -- add LOV here:
3603: -- Note: The REPLACE function replaces all the space characters with
3604: -- the proper escape sequence.
3605: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3606: REPLACE('wf_lov.display_lov?p_lov_name='||'h_to_agent_guid'||
3607: '&p_display_name='||'AGENT'||
3608: '&p_validation_callback=wf_event_html.wf_agent_val'||
3609: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_to_agent_guid.value'||
3610: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_to_agent.value'||

Line 4878: wf_lov.g_define_rec.total_rows := l_total_rows;

4874: upper(substr(p_display_value, 2, 1))||'%'
4875: or NAME like initcap(substr(p_display_value, 1, 2))||'%'
4876: or NAME like upper(substr(p_display_value, 1, 2))||'%'));
4877:
4878: wf_lov.g_define_rec.total_rows := l_total_rows;
4879: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
4880:
4881: open evcurs (p_display_value);
4882: loop

Line 4879: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');

4875: or NAME like initcap(substr(p_display_value, 1, 2))||'%'
4876: or NAME like upper(substr(p_display_value, 1, 2))||'%'));
4877:
4878: wf_lov.g_define_rec.total_rows := l_total_rows;
4879: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
4880:
4881: open evcurs (p_display_value);
4882: loop
4883: fetch evcurs into l_guid, l_name, l_display_name;

Line 4891: wf_lov.g_value_tbl(nn).hidden_key := l_guid;

4887:
4888: if (ii >= p_start_row) then
4889:
4890: nn := nn + 1;
4891: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
4892: wf_lov.g_value_tbl(nn).display_value := l_name;
4893: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
4894: end if;
4895: end loop;

Line 4892: wf_lov.g_value_tbl(nn).display_value := l_name;

4888: if (ii >= p_start_row) then
4889:
4890: nn := nn + 1;
4891: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
4892: wf_lov.g_value_tbl(nn).display_value := l_name;
4893: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
4894: end if;
4895: end loop;
4896: l_result := 1;

Line 4893: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;

4889:
4890: nn := nn + 1;
4891: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
4892: wf_lov.g_value_tbl(nn).display_value := l_name;
4893: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
4894: end if;
4895: end loop;
4896: l_result := 1;
4897:

Line 5009: wf_lov.g_define_rec.total_rows := l_total_rows;

5005: where upper(DISPLAY_NAME) like upper(p_display_value)||'%'
5006: or
5007: upper(NAME) like upper(p_display_value)||'%';
5008:
5009: wf_lov.g_define_rec.total_rows := l_total_rows;
5010: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5011:
5012: open mycurs (p_display_value);
5013: loop

Line 5010: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');

5006: or
5007: upper(NAME) like upper(p_display_value)||'%';
5008:
5009: wf_lov.g_define_rec.total_rows := l_total_rows;
5010: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5011:
5012: open mycurs (p_display_value);
5013: loop
5014: fetch mycurs into l_guid, l_name, l_display_name;

Line 5022: wf_lov.g_value_tbl(nn).hidden_key := l_guid;

5018:
5019: if (ii >= p_start_row) then
5020:
5021: nn := nn + 1;
5022: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5023: wf_lov.g_value_tbl(nn).display_value := l_name;
5024: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5025: end if;
5026: end loop;

Line 5023: wf_lov.g_value_tbl(nn).display_value := l_name;

5019: if (ii >= p_start_row) then
5020:
5021: nn := nn + 1;
5022: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5023: wf_lov.g_value_tbl(nn).display_value := l_name;
5024: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5025: end if;
5026: end loop;
5027: l_result := 1;

Line 5024: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;

5020:
5021: nn := nn + 1;
5022: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5023: wf_lov.g_value_tbl(nn).display_value := l_name;
5024: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5025: end if;
5026: end loop;
5027: l_result := 1;
5028:

Line 5167: wf_lov.g_define_rec.total_rows := l_total_rows;

5163: and A.SYSTEM_GUID = S.GUID
5164: and (p_param1 is null or A.DIRECTION = p_param1)
5165: and (l_sguid is null or A.SYSTEM_GUID = l_sguid);
5166:
5167: wf_lov.g_define_rec.total_rows := l_total_rows;
5168: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5169:
5170: open mycurs (l_aname, l_sguid);
5171: loop

Line 5168: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');

5164: and (p_param1 is null or A.DIRECTION = p_param1)
5165: and (l_sguid is null or A.SYSTEM_GUID = l_sguid);
5166:
5167: wf_lov.g_define_rec.total_rows := l_total_rows;
5168: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5169:
5170: open mycurs (l_aname, l_sguid);
5171: loop
5172: fetch mycurs into l_guid, l_dname, l_disp;

Line 5180: wf_lov.g_value_tbl(nn).hidden_key := l_guid;

5176:
5177: if (ii >= p_start_row) then
5178:
5179: nn := nn + 1;
5180: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5181: wf_lov.g_value_tbl(nn).display_value := l_disp;
5182: wf_lov.g_value_tbl(nn).add_attr1_value := l_dname;
5183: end if;
5184: end loop;

Line 5181: wf_lov.g_value_tbl(nn).display_value := l_disp;

5177: if (ii >= p_start_row) then
5178:
5179: nn := nn + 1;
5180: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5181: wf_lov.g_value_tbl(nn).display_value := l_disp;
5182: wf_lov.g_value_tbl(nn).add_attr1_value := l_dname;
5183: end if;
5184: end loop;
5185: l_result := 1;

Line 5182: wf_lov.g_value_tbl(nn).add_attr1_value := l_dname;

5178:
5179: nn := nn + 1;
5180: wf_lov.g_value_tbl(nn).hidden_key := l_guid;
5181: wf_lov.g_value_tbl(nn).display_value := l_disp;
5182: wf_lov.g_value_tbl(nn).add_attr1_value := l_dname;
5183: end if;
5184: end loop;
5185: l_result := 1;
5186:

Line 5300: wf_lov.g_define_rec.total_rows := l_total_rows;

5296: or
5297: NAME like upper(p_display_value)||'%')
5298: and NAME not in ('WFSTD', 'WFERROR', 'WFMAIL', 'SYSERROR');
5299:
5300: wf_lov.g_define_rec.total_rows := l_total_rows;
5301: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5302:
5303: open mycurs (p_display_value);
5304: loop

Line 5301: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');

5297: NAME like upper(p_display_value)||'%')
5298: and NAME not in ('WFSTD', 'WFERROR', 'WFMAIL', 'SYSERROR');
5299:
5300: wf_lov.g_define_rec.total_rows := l_total_rows;
5301: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5302:
5303: open mycurs (p_display_value);
5304: loop
5305: fetch mycurs into l_name, l_display_name;

Line 5313: wf_lov.g_value_tbl(nn).hidden_key := l_display_name;

5309:
5310: if (ii >= p_start_row) then
5311:
5312: nn := nn + 1;
5313: wf_lov.g_value_tbl(nn).hidden_key := l_display_name;
5314: wf_lov.g_value_tbl(nn).display_value := l_name;
5315: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5316: end if;
5317: end loop;

Line 5314: wf_lov.g_value_tbl(nn).display_value := l_name;

5310: if (ii >= p_start_row) then
5311:
5312: nn := nn + 1;
5313: wf_lov.g_value_tbl(nn).hidden_key := l_display_name;
5314: wf_lov.g_value_tbl(nn).display_value := l_name;
5315: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5316: end if;
5317: end loop;
5318: l_result := 1;

Line 5315: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;

5311:
5312: nn := nn + 1;
5313: wf_lov.g_value_tbl(nn).hidden_key := l_display_name;
5314: wf_lov.g_value_tbl(nn).display_value := l_name;
5315: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5316: end if;
5317: end loop;
5318: l_result := 1;
5319:

Line 5432: wf_lov.g_define_rec.total_rows := l_total_rows;

5428: from WF_RUNNABLE_PROCESSES_V
5429: where PROCESS_NAME like upper(p_display_value)||'%'
5430: and ITEM_TYPE = p_param1;
5431:
5432: wf_lov.g_define_rec.total_rows := l_total_rows;
5433: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5434:
5435: open mycurs (p_display_value);
5436: loop

Line 5433: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');

5429: where PROCESS_NAME like upper(p_display_value)||'%'
5430: and ITEM_TYPE = p_param1;
5431:
5432: wf_lov.g_define_rec.total_rows := l_total_rows;
5433: wf_lov.g_define_rec.add_attr1_title := wf_core.translate('DISPLAY_NAME');
5434:
5435: open mycurs (p_display_value);
5436: loop
5437: fetch mycurs into l_name, l_display_name;

Line 5445: wf_lov.g_value_tbl(nn).hidden_key := p_hidden_value;

5441:
5442: if (ii >= p_start_row) then
5443:
5444: nn := nn + 1;
5445: wf_lov.g_value_tbl(nn).hidden_key := p_hidden_value;
5446: wf_lov.g_value_tbl(nn).display_value := l_name;
5447: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5448: end if;
5449: end loop;

Line 5446: wf_lov.g_value_tbl(nn).display_value := l_name;

5442: if (ii >= p_start_row) then
5443:
5444: nn := nn + 1;
5445: wf_lov.g_value_tbl(nn).hidden_key := p_hidden_value;
5446: wf_lov.g_value_tbl(nn).display_value := l_name;
5447: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5448: end if;
5449: end loop;
5450: l_result := 1;

Line 5447: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;

5443:
5444: nn := nn + 1;
5445: wf_lov.g_value_tbl(nn).hidden_key := p_hidden_value;
5446: wf_lov.g_value_tbl(nn).display_value := l_name;
5447: wf_lov.g_value_tbl(nn).add_attr1_value := l_display_name;
5448: end if;
5449: end loop;
5450: l_result := 1;
5451: