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 402: standard_code = X_STANDARD_CODE,

398: action_code = X_ACTION_CODE,
399: on_error_code = X_ON_ERROR_CODE,
400: java_rule_func = X_JAVA_RULE_FUNC,
401: map_code = X_MAP_CODE,
402: standard_code = X_STANDARD_CODE,
403: standard_type = X_STANDARD_TYPE
404: where guid = X_GUID;
405:
406: l_raise_event_flag := 'Y';

Line 403: standard_type = X_STANDARD_TYPE

399: on_error_code = X_ON_ERROR_CODE,
400: java_rule_func = X_JAVA_RULE_FUNC,
401: map_code = X_MAP_CODE,
402: standard_code = X_STANDARD_CODE,
403: standard_type = X_STANDARD_TYPE
404: where guid = X_GUID;
405:
406: l_raise_event_flag := 'Y';
407:

Line 455: standard_code = X_STANDARD_CODE,

451: action_code = X_ACTION_CODE,
452: on_error_code = X_ON_ERROR_CODE,
453: java_rule_func = X_JAVA_RULE_FUNC,
454: map_code = X_MAP_CODE,
455: standard_code = X_STANDARD_CODE,
456: standard_type = X_STANDARD_TYPE
457: where guid = X_GUID;
458:
459: l_raise_event_flag := 'Y';

Line 456: standard_type = X_STANDARD_TYPE

452: on_error_code = X_ON_ERROR_CODE,
453: java_rule_func = X_JAVA_RULE_FUNC,
454: map_code = X_MAP_CODE,
455: standard_code = X_STANDARD_CODE,
456: standard_type = X_STANDARD_TYPE
457: where guid = X_GUID;
458:
459: l_raise_event_flag := 'Y';
460: else

Line 510: X_STANDARD_CODE in varchar2,

506: X_ACTION_CODE in varchar2,
507: X_ON_ERROR_CODE in varchar2,
508: X_JAVA_RULE_FUNC in varchar2,
509: X_MAP_CODE in varchar2,
510: X_STANDARD_CODE in varchar2,
511: X_STANDARD_TYPE in varchar2
512: ) is
513: row_id varchar2(64);
514: begin

Line 511: X_STANDARD_TYPE in varchar2

507: X_ON_ERROR_CODE in varchar2,
508: X_JAVA_RULE_FUNC in varchar2,
509: X_MAP_CODE in varchar2,
510: X_STANDARD_CODE in varchar2,
511: X_STANDARD_TYPE in varchar2
512: ) is
513: row_id varchar2(64);
514: begin
515: begin

Line 542: X_STANDARD_CODE => X_STANDARD_CODE,

538: X_ACTION_CODE => X_ACTION_CODE,
539: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
540: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
541: X_MAP_CODE => X_MAP_CODE,
542: X_STANDARD_CODE => X_STANDARD_CODE,
543: X_STANDARD_TYPE => X_STANDARD_TYPE
544: );
545: exception
546: when no_data_found then

Line 543: X_STANDARD_TYPE => X_STANDARD_TYPE

539: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
540: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
541: X_MAP_CODE => X_MAP_CODE,
542: X_STANDARD_CODE => X_STANDARD_CODE,
543: X_STANDARD_TYPE => X_STANDARD_TYPE
544: );
545: exception
546: when no_data_found then
547: WF_EVENT_SUBSCRIPTIONS_PKG.INSERT_ROW(

Line 574: X_STANDARD_CODE => X_STANDARD_CODE,

570: X_ACTION_CODE => X_ACTION_CODE,
571: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
572: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
573: X_MAP_CODE => X_MAP_CODE,
574: X_STANDARD_CODE => X_STANDARD_CODE,
575: X_STANDARD_TYPE => X_STANDARD_TYPE
576: );
577: end;
578:

Line 575: X_STANDARD_TYPE => X_STANDARD_TYPE

571: X_ON_ERROR_CODE => X_ON_ERROR_CODE,
572: X_JAVA_RULE_FUNC => X_JAVA_RULE_FUNC,
573: X_MAP_CODE => X_MAP_CODE,
574: X_STANDARD_CODE => X_STANDARD_CODE,
575: X_STANDARD_TYPE => X_STANDARD_TYPE
576: );
577: end;
578:
579: -- Invalidate cache

Line 630: X_STANDARD_CODE in varchar2,

626: X_ACTION_CODE in varchar2,
627: X_ON_ERROR_CODE in varchar2,
628: X_JAVA_RULE_FUNC in varchar2,
629: X_MAP_CODE in varchar2,
630: X_STANDARD_CODE in varchar2,
631: X_STANDARD_TYPE in varchar2
632: ) is
633: begin
634: delete from wf_event_subscriptions

Line 631: X_STANDARD_TYPE in varchar2

627: X_ON_ERROR_CODE in varchar2,
628: X_JAVA_RULE_FUNC in varchar2,
629: X_MAP_CODE in varchar2,
630: X_STANDARD_CODE in varchar2,
631: X_STANDARD_TYPE in varchar2
632: ) is
633: begin
634: delete from wf_event_subscriptions
635: where (X_SYSTEM_GUID is null or (X_SYSTEM_GUID is not null

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

675: and (X_JAVA_RULE_FUNC is null or (X_JAVA_RULE_FUNC is not null
676: and java_rule_func like X_JAVA_RULE_FUNC))
677: and (X_MAP_CODE is null or (X_MAP_CODE is not null
678: and map_code like X_MAP_CODE))
679: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
680: and standard_code like X_STANDARD_CODE))
681: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
682: and standard_type like X_STANDARD_TYPE));
683:

Line 680: and standard_code like X_STANDARD_CODE))

676: and java_rule_func like X_JAVA_RULE_FUNC))
677: and (X_MAP_CODE is null or (X_MAP_CODE is not null
678: and map_code like X_MAP_CODE))
679: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
680: and standard_code like X_STANDARD_CODE))
681: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
682: and standard_type like X_STANDARD_TYPE));
683:
684: -- Invalidate cache

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

677: and (X_MAP_CODE is null or (X_MAP_CODE is not null
678: and map_code like X_MAP_CODE))
679: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
680: and standard_code like X_STANDARD_CODE))
681: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
682: and standard_type like X_STANDARD_TYPE));
683:
684: -- Invalidate cache
685: wf_bes_cache.SetMetaDataUploaded();

Line 682: and standard_type like X_STANDARD_TYPE));

678: and map_code like X_MAP_CODE))
679: and (X_STANDARD_CODE is null or (X_STANDARD_CODE is not null
680: and standard_code like X_STANDARD_CODE))
681: and (X_STANDARD_TYPE is null or (X_STANDARD_TYPE is not null
682: and standard_type like X_STANDARD_TYPE));
683:
684: -- Invalidate cache
685: wf_bes_cache.SetMetaDataUploaded();
686: exception

Line 728: l_standardtype varchar2(30);

724: l_expression varchar2(4000);
725:
726: --Bug 3328673
727: --JBES Support for loader
728: l_standardtype varchar2(30);
729: l_standardcode varchar2(30);
730: l_javarulefunc varchar2(240);
731: l_onerror varchar2(30);
732: l_actioncode varchar2(30);

Line 729: l_standardcode varchar2(30);

725:
726: --Bug 3328673
727: --JBES Support for loader
728: l_standardtype varchar2(30);
729: l_standardcode varchar2(30);
730: l_javarulefunc varchar2(240);
731: l_onerror varchar2(30);
732: l_actioncode varchar2(30);
733: begin

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

737: s.out_agent_guid, s.to_agent_guid, s.priority,
738: s.rule_function, s.wf_process_type, s.wf_process_name,
739: s.parameters, s.owner_name, s.owner_tag, s.description, s.expression,
740: nvl(s.customization_level, 'L'), nvl(s.licensed_flag, 'Y'),
741: s.standard_type , s.standard_code , s.java_rule_func , s.on_error_code,
742: s.action_code
743: into l_system_guid, l_source_type, l_source_agent_guid,
744: l_event_filter_name, l_phase, l_status, l_rule_data,
745: l_out_agent_guid, l_to_agent_guid, l_priority,

Line 748: l_customization_level, l_licensed_flag,l_standardtype,l_standardcode,

744: l_event_filter_name, l_phase, l_status, l_rule_data,
745: l_out_agent_guid, l_to_agent_guid, l_priority,
746: l_rule_function, l_wf_process_type, l_wf_process_name,
747: l_parameters, l_owner_name, l_owner_tag, l_description, l_expression,
748: l_customization_level, l_licensed_flag,l_standardtype,l_standardcode,
749: l_javarulefunc,l_onerror , l_actioncode
750: from wf_event_subscriptions s, wf_events e
751: where s.guid = x_guid
752: and e.guid = s.event_filter_guid;

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

784: --Bug 3328673
785: --Add new tags for JBES support
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',

Line 789: l_standardtype);

785: --Add new tags for JBES support
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);

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

786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',

Line 791: l_standardcode);

787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
795: l_actioncode);

Line 862: l_standardtype varchar2(30);

858:
859: l_num number;
860: --Bug 3328673
861: --JBES Support for loader
862: l_standardtype varchar2(30);
863: l_standardcode varchar2(30);
864: l_javarulefunc varchar2(240);
865: l_onerror varchar2(30);
866: l_actioncode varchar2(30);

Line 863: l_standardcode varchar2(30);

859: l_num number;
860: --Bug 3328673
861: --JBES Support for loader
862: l_standardtype varchar2(30);
863: l_standardcode varchar2(30);
864: l_javarulefunc varchar2(240);
865: l_onerror varchar2(30);
866: l_actioncode varchar2(30);
867:

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

949: --Bug 3328673
950: --JBES Support for loader
951: elsif(l_node_name = 'JAVA_RULE_FUNC') then
952: l_javarulefunc := l_value;
953: elsif(l_node_name = 'STANDARD_TYPE') then
954: l_standardtype := l_value;
955: elsif(l_node_name = 'STANDARD_CODE') then
956: l_standardcode := l_value;
957: elsif(l_node_name = 'ON_ERROR_CODE') then

Line 954: l_standardtype := l_value;

950: --JBES Support for loader
951: elsif(l_node_name = 'JAVA_RULE_FUNC') then
952: l_javarulefunc := l_value;
953: elsif(l_node_name = 'STANDARD_TYPE') then
954: l_standardtype := l_value;
955: elsif(l_node_name = 'STANDARD_CODE') then
956: l_standardcode := l_value;
957: elsif(l_node_name = 'ON_ERROR_CODE') then
958: l_onerror := l_value;

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

951: elsif(l_node_name = 'JAVA_RULE_FUNC') then
952: l_javarulefunc := l_value;
953: elsif(l_node_name = 'STANDARD_TYPE') then
954: l_standardtype := l_value;
955: elsif(l_node_name = 'STANDARD_CODE') then
956: l_standardcode := l_value;
957: elsif(l_node_name = 'ON_ERROR_CODE') then
958: l_onerror := l_value;
959: elsif(l_node_name = 'ACTION_CODE') then

Line 956: l_standardcode := l_value;

952: l_javarulefunc := l_value;
953: elsif(l_node_name = 'STANDARD_TYPE') then
954: l_standardtype := l_value;
955: elsif(l_node_name = 'STANDARD_CODE') then
956: l_standardcode := l_value;
957: elsif(l_node_name = 'ON_ERROR_CODE') then
958: l_onerror := l_value;
959: elsif(l_node_name = 'ACTION_CODE') then
960: l_actioncode := l_value;

Line 1043: X_STANDARD_CODE => l_standardcode,

1039: X_EXPRESSION => l_expression,
1040: X_ACTION_CODE => l_actioncode,
1041: X_ON_ERROR_CODE => l_onerror ,
1042: X_JAVA_RULE_FUNC => l_javarulefunc,
1043: X_STANDARD_CODE => l_standardcode,
1044: X_STANDARD_TYPE => l_standardtype
1045: );
1046:
1047: exception

Line 1044: X_STANDARD_TYPE => l_standardtype

1040: X_ACTION_CODE => l_actioncode,
1041: X_ON_ERROR_CODE => l_onerror ,
1042: X_JAVA_RULE_FUNC => l_javarulefunc,
1043: X_STANDARD_CODE => l_standardcode,
1044: X_STANDARD_TYPE => l_standardtype
1045: );
1046:
1047: exception
1048: when others then