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.WF_EVENT_SUBSCRIPTIONS_PKG dependencies on STANDARD

Line 57: X_STANDARD_CODE in varchar2,

53: X_ACTION_CODE in varchar2,
54: X_ON_ERROR_CODE in varchar2,
55: X_JAVA_RULE_FUNC in varchar2,
56: X_MAP_CODE in varchar2,
57: X_STANDARD_CODE in varchar2,
58: X_STANDARD_TYPE in varchar2
59: ) is
60:
61: l_guid raw(16);

Line 58: X_STANDARD_TYPE in varchar2

54: X_ON_ERROR_CODE in varchar2,
55: X_JAVA_RULE_FUNC in varchar2,
56: X_MAP_CODE in varchar2,
57: X_STANDARD_CODE in varchar2,
58: X_STANDARD_TYPE in varchar2
59: ) is
60:
61: l_guid raw(16);
62: l_event_name varchar2(240);

Line 139: standard_code,

135: action_code,
136: on_error_code,
137: java_rule_func,
138: map_code,
139: standard_code,
140: standard_type
141: ) select X_GUID,
142: X_SYSTEM_GUID,
143: X_SOURCE_TYPE,

Line 140: standard_type

136: on_error_code,
137: java_rule_func,
138: map_code,
139: standard_code,
140: standard_type
141: ) select X_GUID,
142: X_SYSTEM_GUID,
143: X_SOURCE_TYPE,
144: X_SOURCE_AGENT_GUID,

Line 166: X_STANDARD_CODE,

162: X_ACTION_CODE,
163: X_ON_ERROR_CODE,
164: X_JAVA_RULE_FUNC,
165: X_MAP_CODE,
166: X_STANDARD_CODE,
167: X_STANDARD_TYPE
168: from dual where not exists (
169: select 'duplicate'
170: from wf_event_subscriptions

Line 167: X_STANDARD_TYPE

163: X_ON_ERROR_CODE,
164: X_JAVA_RULE_FUNC,
165: X_MAP_CODE,
166: X_STANDARD_CODE,
167: X_STANDARD_TYPE
168: from dual where not exists (
169: select 'duplicate'
170: from wf_event_subscriptions
171: where guid = X_GUID);

Line 218: X_STANDARD_CODE in varchar2,

214: X_ACTION_CODE in varchar2,
215: X_ON_ERROR_CODE in varchar2,
216: X_JAVA_RULE_FUNC in varchar2,
217: X_MAP_CODE in varchar2,
218: X_STANDARD_CODE in varchar2,
219: X_STANDARD_TYPE in varchar2
220: ) is
221: l_custom_level varchar2(1);
222: l_update_allowed varchar2(1) := 'Y';

Line 219: X_STANDARD_TYPE in varchar2

215: X_ON_ERROR_CODE in varchar2,
216: X_JAVA_RULE_FUNC in varchar2,
217: X_MAP_CODE in varchar2,
218: X_STANDARD_CODE in varchar2,
219: X_STANDARD_TYPE in varchar2
220: ) is
221: l_custom_level varchar2(1);
222: l_update_allowed varchar2(1) := 'Y';
223: l_licensed_flag varchar2(1) := 'N';

Line 303: standard_code = X_STANDARD_CODE,

299: action_code = X_ACTION_CODE,
300: on_error_code = X_ON_ERROR_CODE,
301: java_rule_func = X_JAVA_RULE_FUNC,
302: map_code = X_MAP_CODE,
303: standard_code = X_STANDARD_CODE,
304: standard_type = X_STANDARD_TYPE
305: where guid = X_GUID;
306:
307: if (sql%notfound) then

Line 304: standard_type = X_STANDARD_TYPE

300: on_error_code = X_ON_ERROR_CODE,
301: java_rule_func = X_JAVA_RULE_FUNC,
302: map_code = X_MAP_CODE,
303: standard_code = X_STANDARD_CODE,
304: standard_type = X_STANDARD_TYPE
305: where guid = X_GUID;
306:
307: if (sql%notfound) then
308: raise no_data_found;

Line 355: standard_code = X_STANDARD_CODE,

351: action_code = X_ACTION_CODE,
352: on_error_code = X_ON_ERROR_CODE,
353: java_rule_func = X_JAVA_RULE_FUNC,
354: map_code = X_MAP_CODE,
355: standard_code = X_STANDARD_CODE,
356: standard_type = X_STANDARD_TYPE
357: where guid = X_GUID;
358:
359: l_raise_event_flag := 'Y';

Line 356: standard_type = X_STANDARD_TYPE

352: on_error_code = X_ON_ERROR_CODE,
353: java_rule_func = X_JAVA_RULE_FUNC,
354: map_code = X_MAP_CODE,
355: standard_code = X_STANDARD_CODE,
356: standard_type = X_STANDARD_TYPE
357: where guid = X_GUID;
358:
359: l_raise_event_flag := 'Y';
360: else

Line 395: standard_code = X_STANDARD_CODE,

391: action_code = X_ACTION_CODE,
392: on_error_code = X_ON_ERROR_CODE,
393: java_rule_func = X_JAVA_RULE_FUNC,
394: map_code = X_MAP_CODE,
395: standard_code = X_STANDARD_CODE,
396: standard_type = X_STANDARD_TYPE
397: where guid = X_GUID;
398:
399: l_raise_event_flag := 'Y';

Line 396: standard_type = X_STANDARD_TYPE

392: on_error_code = X_ON_ERROR_CODE,
393: java_rule_func = X_JAVA_RULE_FUNC,
394: map_code = X_MAP_CODE,
395: standard_code = X_STANDARD_CODE,
396: standard_type = X_STANDARD_TYPE
397: where guid = X_GUID;
398:
399: l_raise_event_flag := 'Y';
400:

Line 444: standard_code = X_STANDARD_CODE,

440: action_code = X_ACTION_CODE,
441: on_error_code = X_ON_ERROR_CODE,
442: java_rule_func = X_JAVA_RULE_FUNC,
443: map_code = X_MAP_CODE,
444: standard_code = X_STANDARD_CODE,
445: standard_type = X_STANDARD_TYPE
446: where guid = X_GUID;
447:
448: l_raise_event_flag := 'Y';

Line 445: standard_type = X_STANDARD_TYPE

441: on_error_code = X_ON_ERROR_CODE,
442: java_rule_func = X_JAVA_RULE_FUNC,
443: map_code = X_MAP_CODE,
444: standard_code = X_STANDARD_CODE,
445: standard_type = X_STANDARD_TYPE
446: where guid = X_GUID;
447:
448: l_raise_event_flag := 'Y';
449: else

Line 497: X_STANDARD_CODE in varchar2,

493: X_ACTION_CODE in varchar2,
494: X_ON_ERROR_CODE in varchar2,
495: X_JAVA_RULE_FUNC in varchar2,
496: X_MAP_CODE in varchar2,
497: X_STANDARD_CODE in varchar2,
498: X_STANDARD_TYPE in varchar2
499: ) is
500: row_id varchar2(64);
501: begin

Line 498: X_STANDARD_TYPE in varchar2

494: X_ON_ERROR_CODE in varchar2,
495: X_JAVA_RULE_FUNC in varchar2,
496: X_MAP_CODE in varchar2,
497: X_STANDARD_CODE in varchar2,
498: X_STANDARD_TYPE in varchar2
499: ) is
500: row_id varchar2(64);
501: begin
502: begin

Line 529: X_STANDARD_CODE => X_STANDARD_CODE,

525: X_ACTION_CODE => X_ACTION_CODE,
526: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
527: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
528: X_MAP_CODE => X_MAP_CODE,
529: X_STANDARD_CODE => X_STANDARD_CODE,
530: X_STANDARD_TYPE => X_STANDARD_TYPE
531: );
532: exception
533: when no_data_found then

Line 530: X_STANDARD_TYPE => X_STANDARD_TYPE

526: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
527: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
528: X_MAP_CODE => X_MAP_CODE,
529: X_STANDARD_CODE => X_STANDARD_CODE,
530: X_STANDARD_TYPE => X_STANDARD_TYPE
531: );
532: exception
533: when no_data_found then
534: WF_EVENT_SUBSCRIPTIONS_PKG.INSERT_ROW(

Line 561: X_STANDARD_CODE => X_STANDARD_CODE,

557: X_ACTION_CODE => X_ACTION_CODE,
558: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
559: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
560: X_MAP_CODE => X_MAP_CODE,
561: X_STANDARD_CODE => X_STANDARD_CODE,
562: X_STANDARD_TYPE => X_STANDARD_TYPE
563: );
564: end;
565:

Line 562: X_STANDARD_TYPE => X_STANDARD_TYPE

558: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
559: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
560: X_MAP_CODE => X_MAP_CODE,
561: X_STANDARD_CODE => X_STANDARD_CODE,
562: X_STANDARD_TYPE => X_STANDARD_TYPE
563: );
564: end;
565:
566: -- Invalidate cache

Line 617: X_STANDARD_CODE in varchar2,

613: X_ACTION_CODE in varchar2,
614: X_ON_ERROR_CODE in varchar2,
615: X_JAVA_RULE_FUNC in varchar2,
616: X_MAP_CODE in varchar2,
617: X_STANDARD_CODE in varchar2,
618: X_STANDARD_TYPE in varchar2
619: ) is
620: begin
621: delete from wf_event_subscriptions

Line 618: X_STANDARD_TYPE in varchar2

614: X_ON_ERROR_CODE in varchar2,
615: X_JAVA_RULE_FUNC in varchar2,
616: X_MAP_CODE in varchar2,
617: X_STANDARD_CODE in varchar2,
618: X_STANDARD_TYPE in varchar2
619: ) is
620: begin
621: delete from wf_event_subscriptions
622: where (X_SYSTEM_GUID is null or (X_SYSTEM_GUID is not null

Line 666: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null

662: and (X_JAVA_RULE_FUNC is null or (X_JAVA_RULE_FUNC is not null
663: and java_rule_func like X_JAVA_RULE_FUNC))
664: and (X_MAP_CODE is null or (X_MAP_CODE is not null
665: and map_code like X_MAP_CODE))
666: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
667: and standard_code like X_STANDARD_CODE))
668: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
669: and standard_type like X_STANDARD_TYPE));
670:

Line 667: and standard_code like X_STANDARD_CODE))

663: and java_rule_func like X_JAVA_RULE_FUNC))
664: and (X_MAP_CODE is null or (X_MAP_CODE is not null
665: and map_code like X_MAP_CODE))
666: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
667: and standard_code like X_STANDARD_CODE))
668: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
669: and standard_type like X_STANDARD_TYPE));
670:
671: -- Invalidate cache

Line 668: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null

664: and (X_MAP_CODE is null or (X_MAP_CODE is not null
665: and map_code like X_MAP_CODE))
666: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
667: and standard_code like X_STANDARD_CODE))
668: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
669: and standard_type like X_STANDARD_TYPE));
670:
671: -- Invalidate cache
672: wf_bes_cache.SetMetaDataUploaded();

Line 669: and standard_type like X_STANDARD_TYPE));

665: and map_code like X_MAP_CODE))
666: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
667: and standard_code like X_STANDARD_CODE))
668: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
669: and standard_type like X_STANDARD_TYPE));
670:
671: -- Invalidate cache
672: wf_bes_cache.SetMetaDataUploaded();
673: exception

Line 715: l_standardtype varchar2(30);

711: l_expression varchar2(4000);
712:
713: --Bug 3328673
714: --JBES Support for loader
715: l_standardtype varchar2(30);
716: l_standardcode varchar2(30);
717: l_javarulefunc varchar2(240);
718: l_onerror varchar2(30);
719: l_actioncode varchar2(30);

Line 716: l_standardcode varchar2(30);

712:
713: --Bug 3328673
714: --JBES Support for loader
715: l_standardtype varchar2(30);
716: l_standardcode varchar2(30);
717: l_javarulefunc varchar2(240);
718: l_onerror varchar2(30);
719: l_actioncode varchar2(30);
720: begin

Line 728: s.standard_type , s.standard_code , s.java_rule_func , s.on_error_code,

724: s.out_agent_guid, s.to_agent_guid, s.priority,
725: s.rule_function, s.wf_process_type, s.wf_process_name,
726: s.parameters, s.owner_name, s.owner_tag, s.description, s.expression,
727: nvl(s.customization_level, 'L'), nvl(s.licensed_flag, 'Y'),
728: s.standard_type , s.standard_code , s.java_rule_func , s.on_error_code,
729: s.action_code
730: into l_system_guid, l_source_type, l_source_agent_guid,
731: l_event_filter_name, l_phase, l_status, l_rule_data,
732: l_out_agent_guid, l_to_agent_guid, l_priority,

Line 735: l_customization_level, l_licensed_flag,l_standardtype,l_standardcode,

731: l_event_filter_name, l_phase, l_status, l_rule_data,
732: l_out_agent_guid, l_to_agent_guid, l_priority,
733: l_rule_function, l_wf_process_type, l_wf_process_name,
734: l_parameters, l_owner_name, l_owner_tag, l_description, l_expression,
735: l_customization_level, l_licensed_flag,l_standardtype,l_standardcode,
736: l_javarulefunc,l_onerror , l_actioncode
737: from wf_event_subscriptions s, wf_events e
738: where s.guid = x_guid
739: and e.guid = s.event_filter_guid;

Line 775: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',

771: --Bug 3328673
772: --Add new tags for JBES support
773: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
774: l_javarulefunc);
775: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
776: l_standardtype);
777: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
778: l_standardcode);
779: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',

Line 776: l_standardtype);

772: --Add new tags for JBES support
773: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
774: l_javarulefunc);
775: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
776: l_standardtype);
777: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
778: l_standardcode);
779: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
780: l_onerror);

Line 777: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',

773: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
774: l_javarulefunc);
775: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
776: l_standardtype);
777: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
778: l_standardcode);
779: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
780: l_onerror);
781: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',

Line 778: l_standardcode);

774: l_javarulefunc);
775: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
776: l_standardtype);
777: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
778: l_standardcode);
779: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
780: l_onerror);
781: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
782: l_actioncode);

Line 849: l_standardtype varchar2(30);

845:
846: l_num number;
847: --Bug 3328673
848: --JBES Support for loader
849: l_standardtype varchar2(30);
850: l_standardcode varchar2(30);
851: l_javarulefunc varchar2(240);
852: l_onerror varchar2(30);
853: l_actioncode varchar2(30);

Line 850: l_standardcode varchar2(30);

846: l_num number;
847: --Bug 3328673
848: --JBES Support for loader
849: l_standardtype varchar2(30);
850: l_standardcode varchar2(30);
851: l_javarulefunc varchar2(240);
852: l_onerror varchar2(30);
853: l_actioncode varchar2(30);
854:

Line 940: elsif(l_node_name = 'STANDARD_TYPE') then

936: --Bug 3328673
937: --JBES Support for loader
938: elsif(l_node_name = 'JAVA_RULE_FUNC') then
939: l_javarulefunc := l_value;
940: elsif(l_node_name = 'STANDARD_TYPE') then
941: l_standardtype := l_value;
942: elsif(l_node_name = 'STANDARD_CODE') then
943: l_standardcode := l_value;
944: elsif(l_node_name = 'ON_ERROR_CODE') then

Line 941: l_standardtype := l_value;

937: --JBES Support for loader
938: elsif(l_node_name = 'JAVA_RULE_FUNC') then
939: l_javarulefunc := l_value;
940: elsif(l_node_name = 'STANDARD_TYPE') then
941: l_standardtype := l_value;
942: elsif(l_node_name = 'STANDARD_CODE') then
943: l_standardcode := l_value;
944: elsif(l_node_name = 'ON_ERROR_CODE') then
945: l_onerror := l_value;

Line 942: elsif(l_node_name = 'STANDARD_CODE') then

938: elsif(l_node_name = 'JAVA_RULE_FUNC') then
939: l_javarulefunc := l_value;
940: elsif(l_node_name = 'STANDARD_TYPE') then
941: l_standardtype := l_value;
942: elsif(l_node_name = 'STANDARD_CODE') then
943: l_standardcode := l_value;
944: elsif(l_node_name = 'ON_ERROR_CODE') then
945: l_onerror := l_value;
946: elsif(l_node_name = 'ACTION_CODE') then

Line 943: l_standardcode := l_value;

939: l_javarulefunc := l_value;
940: elsif(l_node_name = 'STANDARD_TYPE') then
941: l_standardtype := l_value;
942: elsif(l_node_name = 'STANDARD_CODE') then
943: l_standardcode := l_value;
944: elsif(l_node_name = 'ON_ERROR_CODE') then
945: l_onerror := l_value;
946: elsif(l_node_name = 'ACTION_CODE') then
947: l_actioncode := l_value;

Line 1030: X_STANDARD_CODE => l_standardcode,

1026: X_EXPRESSION => l_expression,
1027: X_ACTION_CODE => l_actioncode,
1028: X_ON_ERROR_CODE => l_onerror ,
1029: X_JAVA_RULE_FUNC => l_javarulefunc,
1030: X_STANDARD_CODE => l_standardcode,
1031: X_STANDARD_TYPE => l_standardtype
1032: );
1033:
1034: exception

Line 1031: X_STANDARD_TYPE => l_standardtype

1027: X_ACTION_CODE => l_actioncode,
1028: X_ON_ERROR_CODE => l_onerror ,
1029: X_JAVA_RULE_FUNC => l_javarulefunc,
1030: X_STANDARD_CODE => l_standardcode,
1031: X_STANDARD_TYPE => l_standardtype
1032: );
1033:
1034: exception
1035: when others then