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.EDR_ERES_EVENT_PVT dependencies on WF_EVENT

Line 22: from wf_events_vl a, wf_event_subscriptions b

18: l_no_of_eres_sub NUMBER;
19:
20: cursor enabled_subscription_csr is
21: select b.guid
22: from wf_events_vl a, wf_event_subscriptions b
23: where a.guid=b.EVENT_FILTER_GUID
24: and a.name = p_event_name
25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
26: and b.status = 'ENABLED'

Line 34: from wf_events_vl a, wf_event_subscriptions b

30: --Bug No 4912782- End
31:
32: cursor single_subscription_csr is
33: select b.guid
34: from wf_events_vl a, wf_event_subscriptions b
35: where a.guid=b.EVENT_FILTER_GUID
36: and a.name = p_event_name
37: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
38: --Bug No 4912782- Start

Line 60: wf_events a, wf_event_subscriptions b

56: --
57:
58: select count(*) INTO l_no_of_eres_sub
59: from
60: wf_events a, wf_event_subscriptions b
61: where a.GUID = b.EVENT_FILTER_GUID
62: and a.name = p_event_name
63: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
64: --Bug No 4912782- Start

Line 82: wf_events a, wf_event_subscriptions b

78: --
79: --
80: select count(*) INTO l_no_enabled_eres_sub
81: from
82: wf_events a, wf_event_subscriptions b
83: where a.GUID = b.EVENT_FILTER_GUID
84: and a.name = p_event_name
85: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
86: and b.STATUS = 'ENABLED'

Line 132: p_parameter_list IN FND_WF_EVENT.PARAM_TABLE

128: p_mode IN VARCHAR2,
129: x_event IN OUT NOCOPY EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE,
130: x_is_child_event OUT NOCOPY BOOLEAN,
131: --Bug 4122622: Start
132: p_parameter_list IN FND_WF_EVENT.PARAM_TABLE
133: --Bug 4122622: End
134: )
135: AS
136: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';

Line 139: l_parameter_list fnd_wf_event.param_table;

135: AS
136: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
137: l_api_version CONSTANT NUMBER := 1.0;
138:
139: l_parameter_list fnd_wf_event.param_table;
140: l_param_name varchar2(30);
141: l_param_value varchar2(2000);
142: l_param_number number;
143: i pls_integer;

Line 182: --of type fnd_wf_event.param_table

178:
179: -- CHANGE_SOURCE_TYPE(x_event.payload, EDR_CONSTANTS_GRP.g_db_mode);
180: --Bug 3136403: Start
181: --Copy the individual parameters to a structure
182: --of type fnd_wf_event.param_table
183: --start with 4 because in event of the payload with valid
184: --the first three parameters are set to specific values below
185: -- SKARIMIS Moved the code logic outside of follwing IF statment. Payload should
186: -- be populated without checking validation

Line 437: x_payload OUT NOCOPY FND_WF_EVENT.PARAM_TABLE

433:
434: PROCEDURE CREATE_PAYLOAD
435: ( p_event IN EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE ,
436: p_starting_position IN NUMBER ,
437: x_payload OUT NOCOPY FND_WF_EVENT.PARAM_TABLE
438: )
439: IS
440: l_position number;
441: BEGIN

Line 602: FROM FND_APPLICATION A, WF_EVENTS B

598: INVALID_USER_NAME_ERROR EXCEPTION;
599: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;
600: CURSOR CUR_EVENT is
601: SELECT application_id
602: FROM FND_APPLICATION A, WF_EVENTS B
603: WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
604: AND B.NAME=P_EVENT_NAME;
605:
606: CURSOR CUR_SUB is

Line 609: wf_events a, wf_event_subscriptions b

605:
606: CURSOR CUR_SUB is
607: select count(*)
608: from
609: wf_events a, wf_event_subscriptions b
610: where a.GUID = b.EVENT_FILTER_GUID
611: and a.name = p_event_name
612: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
613: and b.STATUS = 'ENABLED'

Line 672: from wf_events_vl a,

668: --If there are > 1 subscriptions, and one is enabled query returns >1
669: -- rows. Hence adding two more conditions in where clause
670:
671: SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type
672: from wf_events_vl a,
673: wf_event_subscriptions b
674: WHERE a.guid=b.EVENT_FILTER_GUID
675: and a.name = p_event_name
676: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'

Line 673: wf_event_subscriptions b

669: -- rows. Hence adding two more conditions in where clause
670:
671: SELECT EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE',b.guid) into l_ame_txn_type
672: from wf_events_vl a,
673: wf_event_subscriptions b
674: WHERE a.guid=b.EVENT_FILTER_GUID
675: and a.name = p_event_name
676: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
677: and b.STATUS = 'ENABLED'

Line 962: P_ORIG_PARAM_LIST IN FND_WF_EVENT.PARAM_TABLE,

958: --Hence this new API will perform an autonomous commit.
959:
960: PROCEDURE RAISE_COMPLETION_EVENT(P_ORIG_EVENT_NAME IN VARCHAR2,
961: P_ORIG_EVENT_KEY IN VARCHAR2,
962: P_ORIG_PARAM_LIST IN FND_WF_EVENT.PARAM_TABLE,
963: P_SEND_DATE IN DATE)
964: IS
965:
966: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);

1030: else
1031: l_event_key := '-1';
1032: END IF;
1033:
1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);
1035:
1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN

Line 1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);

1032: END IF;
1033:
1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);
1035:
1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);

Line 1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);

1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);
1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE

Line 1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);

1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);
1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE
1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);
1046: END IF;

Line 1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);

1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE
1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);
1046: END IF;
1047:
1048: --Raise the approval completion event.
1049: WF_EVENT.RAISE3(L_EVENT_NAME,

Line 1049: WF_EVENT.RAISE3(L_EVENT_NAME,

1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);
1046: END IF;
1047:
1048: --Raise the approval completion event.
1049: WF_EVENT.RAISE3(L_EVENT_NAME,
1050: L_EVENT_KEY,
1051: null,
1052: L_PARAM_LIST,
1053: P_SEND_DATE);

Line 1062: --This method will be a wrapper over FND_WF_EVENT.RAISE_EVENT

1058:
1059: END RAISE_COMPLETION_EVENT;
1060:
1061:
1062: --This method will be a wrapper over FND_WF_EVENT.RAISE_EVENT
1063: PROCEDURE RAISE_TABLE(P_EVENT_NAME IN VARCHAR2,
1064: P_EVENT_KEY IN VARCHAR2,
1065: P_EVENT_DATA IN CLOB DEFAULT NULL,
1066: P_PARAM_TABLE IN OUT NOCOPY FND_WF_EVENT.PARAM_TABLE,

Line 1066: P_PARAM_TABLE IN OUT NOCOPY FND_WF_EVENT.PARAM_TABLE,

1062: --This method will be a wrapper over FND_WF_EVENT.RAISE_EVENT
1063: PROCEDURE RAISE_TABLE(P_EVENT_NAME IN VARCHAR2,
1064: P_EVENT_KEY IN VARCHAR2,
1065: P_EVENT_DATA IN CLOB DEFAULT NULL,
1066: P_PARAM_TABLE IN OUT NOCOPY FND_WF_EVENT.PARAM_TABLE,
1067: P_NUMBER_PARAMS IN NUMBER,
1068: P_SEND_DATE IN DATE DEFAULT NULL)
1069: IS
1070:

Line 1074: FND_WF_EVENT.RAISE_TABLE(P_EVENT_NAME,

1070:
1071: BEGIN
1072:
1073: --Call the workflow API to raise the event.
1074: FND_WF_EVENT.RAISE_TABLE(P_EVENT_NAME,
1075: P_EVENT_KEY,
1076: P_EVENT_DATA,
1077: P_PARAM_TABLE,
1078: P_NUMBER_PARAMS,