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.AS_BUSINESS_EVENT_PVT dependencies on AS_EVENT_DATA

Line 38: DELETE FROM as_event_data

34: SAVEPOINT Event_data_delete;
35:
36: l_key := p_event.GetEventKey();
37:
38: DELETE FROM as_event_data
39: WHERE event_key = l_key;
40:
41: RETURN 'SUCCESS';
42:

Line 140: insert into AS_EVENT_DATA (

136: p_old_event_key IN VARCHAR2,
137: p_new_event_key IN VARCHAR2
138: ) IS
139: BEGIN
140: insert into AS_EVENT_DATA (
141: EVENT_DATA_ID,
142: EVENT_KEY, OBJECT_STATE,
143: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
144: LAST_UPDATE_LOGIN,

Line 163: AS_EVENT_DATA_S.nextval,

159: DATE01, DATE02, DATE03, DATE04, DATE05, DATE06, DATE07, DATE08,
160: DATE09, DATE10, DATE11, DATE12, DATE13, DATE14, DATE15
161: )
162: select
163: AS_EVENT_DATA_S.nextval,
164: p_new_event_key, OBJECT_STATE,
165: SYSDATE, SYSDATE, CREATED_BY, LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN,
167: CHAR01, CHAR02, CHAR03, CHAR04, CHAR05, CHAR06, CHAR07, CHAR08,

Line 183: from AS_EVENT_DATA where event_key = p_old_event_key;

179: NUM19, NUM20, NUM21, NUM22, NUM23, NUM24, NUM25, NUM26, NUM27,
180: NUM28, NUM29, NUM30,
181: DATE01, DATE02, DATE03, DATE04, DATE05, DATE06, DATE07, DATE08,
182: DATE09, DATE10, DATE11, DATE12, DATE13, DATE14, DATE15
183: from AS_EVENT_DATA where event_key = p_old_event_key;
184: END Copy_Event_Data;
185:
186:
187: -- This function is for subscribing, for testing/debugging of business events,

Line 189: -- which log data to as_event_data table. It copies the event_data to new rows

185:
186:
187: -- This function is for subscribing, for testing/debugging of business events,
188: -- to business events raised by Opportunity and customer sales team modules
189: -- which log data to as_event_data table. It copies the event_data to new rows
190: -- in the same as_event_data table so that the debug data can be seen after it
191: -- is automatically deleted. It creates a new event_key like 'debug',
192: -- The first rows contain the event parameters one by one. The parameter name is
193: -- stored in CHAR01 and value in CHAR02. Two pseudo parameters EVENT_NAME and

Line 190: -- in the same as_event_data table so that the debug data can be seen after it

186:
187: -- This function is for subscribing, for testing/debugging of business events,
188: -- to business events raised by Opportunity and customer sales team modules
189: -- which log data to as_event_data table. It copies the event_data to new rows
190: -- in the same as_event_data table so that the debug data can be seen after it
191: -- is automatically deleted. It creates a new event_key like 'debug',
192: -- The first rows contain the event parameters one by one. The parameter name is
193: -- stored in CHAR01 and value in CHAR02. Two pseudo parameters EVENT_NAME and
194: -- EVENT_KEY are added. The subsequent rows contain as_event_data corresponding

Line 194: -- EVENT_KEY are added. The subsequent rows contain as_event_data corresponding

190: -- in the same as_event_data table so that the debug data can be seen after it
191: -- is automatically deleted. It creates a new event_key like 'debug',
192: -- The first rows contain the event parameters one by one. The parameter name is
193: -- stored in CHAR01 and value in CHAR02. Two pseudo parameters EVENT_NAME and
194: -- EVENT_KEY are added. The subsequent rows contain as_event_data corresponding
195: -- to the event key received. It is the users responsibility to delete these
196: -- debug rows from the as_event_data table.
197: FUNCTION Test_event
198: -- Rule function for event data deletions used as the last subscription to AS events

Line 196: -- debug rows from the as_event_data table.

192: -- The first rows contain the event parameters one by one. The parameter name is
193: -- stored in CHAR01 and value in CHAR02. Two pseudo parameters EVENT_NAME and
194: -- EVENT_KEY are added. The subsequent rows contain as_event_data corresponding
195: -- to the event key received. It is the users responsibility to delete these
196: -- debug rows from the as_event_data table.
197: FUNCTION Test_event
198: -- Rule function for event data deletions used as the last subscription to AS events
199: (p_subscription_guid IN RAW,
200: p_event IN OUT NOCOPY WF_EVENT_T)

Line 228: insert into AS_EVENT_DATA (

224:
225:
226: FOR l_index IN 1..l_parameters.last LOOP
227: l_param := l_parameters(l_index);
228: insert into AS_EVENT_DATA (
229: EVENT_DATA_ID,
230: EVENT_KEY, OBJECT_STATE, CHAR01, CHAR02,
231: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
232: LAST_UPDATE_LOGIN

Line 235: AS_EVENT_DATA_S.nextval,

231: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
232: LAST_UPDATE_LOGIN
233: )
234: values (
235: AS_EVENT_DATA_S.nextval,
236: l_new_key, 'AAA', l_param.GetName(), l_param.GetValue(),
237: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
238: FND_GLOBAL.CONC_LOGIN_ID
239: );

Line 246: insert into AS_EVENT_DATA (

242: l_param.GetName() || ' : ' || l_param.GetValue()) ;
243: END IF;
244: END LOOP;
245:
246: insert into AS_EVENT_DATA (
247: EVENT_DATA_ID,
248: EVENT_KEY, OBJECT_STATE, CHAR01, CHAR02,
249: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
250: LAST_UPDATE_LOGIN

Line 253: AS_EVENT_DATA_S.nextval,

249: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
250: LAST_UPDATE_LOGIN
251: )
252: values (
253: AS_EVENT_DATA_S.nextval,
254: l_new_key, 'AAA', 'EVENT_NAME', l_event_name,
255: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
256: FND_GLOBAL.CONC_LOGIN_ID
257: );

Line 259: insert into AS_EVENT_DATA (

255: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
256: FND_GLOBAL.CONC_LOGIN_ID
257: );
258:
259: insert into AS_EVENT_DATA (
260: EVENT_DATA_ID,
261: EVENT_KEY, OBJECT_STATE, CHAR01, CHAR02,
262: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
263: LAST_UPDATE_LOGIN

Line 266: AS_EVENT_DATA_S.nextval,

262: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
263: LAST_UPDATE_LOGIN
264: )
265: values (
266: AS_EVENT_DATA_S.nextval,
267: l_new_key, 'AAA', 'EVENT_KEY', l_key,
268: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
269: FND_GLOBAL.CONC_LOGIN_ID
270: );

Line 517: insert into AS_EVENT_DATA (

513: p_lead_id IN NUMBER,
514: p_indicator IN VARCHAR2) IS
515: BEGIN
516:
517: insert into AS_EVENT_DATA (
518: EVENT_DATA_ID,
519: EVENT_KEY, OBJECT_STATE,
520: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
521: LAST_UPDATE_LOGIN,

Line 565: AS_EVENT_DATA_S.nextval,

561: CHAR34,
562: CHAR35,
563: CHAR36, CHAR37)
564: select
565: AS_EVENT_DATA_S.nextval,
566: p_item_key, p_indicator,
567: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
568: FND_GLOBAL.CONC_LOGIN_ID,
569:

Line 629: insert into AS_EVENT_DATA (

625: p_lead_id IN NUMBER,
626: p_indicator IN VARCHAR2) IS
627: BEGIN
628:
629: insert into AS_EVENT_DATA (
630: EVENT_DATA_ID,
631: EVENT_KEY, OBJECT_STATE,
632: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
633: LAST_UPDATE_LOGIN,

Line 658: AS_EVENT_DATA_S.nextval,

654: CHAR18, CHAR19,
655: CHAR20, CHAR21,
656: CHAR22)
657: select
658: AS_EVENT_DATA_S.nextval,
659: p_item_key, p_indicator,
660: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
661: FND_GLOBAL.CONC_LOGIN_ID,
662:

Line 702: insert into AS_EVENT_DATA (

698: p_lead_id IN NUMBER,
699: p_indicator IN VARCHAR2) IS
700: BEGIN
701:
702: insert into AS_EVENT_DATA (
703: EVENT_DATA_ID,
704: EVENT_KEY, OBJECT_STATE,
705: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
706: LAST_UPDATE_LOGIN,

Line 710: AS_EVENT_DATA_S.nextval,

706: LAST_UPDATE_LOGIN,
707:
708: NUM01, NUM02, NUM03, NUM04)
709: select
710: AS_EVENT_DATA_S.nextval,
711: p_item_key, p_indicator,
712: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
713: FND_GLOBAL.CONC_LOGIN_ID,
714:

Line 731: insert into AS_EVENT_DATA (

727: p_cust_id IN NUMBER,
728: p_indicator IN VARCHAR2) IS
729: BEGIN
730:
731: insert into AS_EVENT_DATA (
732: EVENT_DATA_ID,
733: EVENT_KEY, OBJECT_STATE,
734: LAST_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATED_BY,
735: LAST_UPDATE_LOGIN,

Line 739: AS_EVENT_DATA_S.nextval,

735: LAST_UPDATE_LOGIN,
736:
737: NUM01, NUM02, NUM03, NUM04, NUM05)
738: select
739: AS_EVENT_DATA_S.nextval,
740: p_item_key, p_indicator,
741: SYSDATE, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID,
742: FND_GLOBAL.CONC_LOGIN_ID,
743:

Line 810: from as_event_data

806: CHAR33,
807: CHAR34,
808: CHAR35,
809: CHAR36, CHAR37
810: from as_event_data
811: where event_key = p_item_key AND object_state = p_indicator;
812:
813: l_old_rec c_opp_data%ROWTYPE;
814: l_new_rec c_opp_data%ROWTYPE;

Line 946: from as_event_data

942: CHAR16, CHAR17,
943: CHAR18, CHAR19,
944: CHAR20, CHAR21,
945: CHAR22, rowid
946: from as_event_data
947: where event_key = p_item_key AND object_state = p_indicator ORDER BY NUM01;
948: -- Order By is to do a sorted list comparison.
949:
950: -- Same cursor as c_opp_line_old

Line 975: from as_event_data

971: CHAR16, CHAR17,
972: CHAR18, CHAR19,
973: CHAR20, CHAR21,
974: CHAR22, rowid
975: from as_event_data
976: where event_key = p_item_key AND object_state = p_indicator ORDER BY NUM01;
977: -- Order By is to do a sorted list comparison.
978:
979: l_old_rec c_opp_line_old%ROWTYPE;

Line 1059: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;

1055: EXIT;
1056: END IF;
1057: ELSE -- Both records match
1058: IF p_delete_flag THEN
1059: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;
1060: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;
1061: END IF;
1062: END IF;
1063: END LOOP;

Line 1060: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;

1056: END IF;
1057: ELSE -- Both records match
1058: IF p_delete_flag THEN
1059: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;
1060: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;
1061: END IF;
1062: END IF;
1063: END LOOP;
1064:

Line 1090: from as_event_data

1086:
1087: Cursor c_sales_team_old(p_item_key VARCHAR2, p_indicator VARCHAR2) IS
1088: select
1089: NUM01, NUM02, NUM03, NUM04, NUM05, rowid
1090: from as_event_data
1091: where event_key = p_item_key AND object_state = p_indicator
1092: ORDER BY NUM01, NUM02, NUM05;
1093: -- Order By is to do a sorted list comparison. Order by Salesforce id and
1094: -- Sales Group Id since access_id is not used.

Line 1100: from as_event_data

1096: -- Same cursor as c_sales_team_old
1097: Cursor c_sales_team_new(p_item_key VARCHAR2, p_indicator VARCHAR2) IS
1098: select
1099: NUM01, NUM02, NUM03, NUM04, NUM05, rowid
1100: from as_event_data
1101: where event_key = p_item_key AND object_state = p_indicator
1102: ORDER BY NUM01, NUM02, NUM05;
1103: -- Order By is to do a sorted list comparison.
1104:

Line 1166: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;

1162: EXIT;
1163: END IF;
1164: ELSE -- Both records match
1165: IF p_delete_flag THEN
1166: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;
1167: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;
1168: END IF;
1169: END IF;
1170: END LOOP;

Line 1167: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;

1163: END IF;
1164: ELSE -- Both records match
1165: IF p_delete_flag THEN
1166: delete from AS_EVENT_DATA where rowid = l_old_rec.rowid;
1167: delete from AS_EVENT_DATA where rowid = l_new_rec.rowid;
1168: END IF;
1169: END IF;
1170: END LOOP;
1171:

Line 1312: delete from AS_EVENT_DATA where event_key = l_event_key;

1308: END LOOP;
1309:
1310: -- If update_event is to be raised then raise it else delete the event_data
1311: IF NOT l_upd_event_raised THEN
1312: delete from AS_EVENT_DATA where event_key = l_event_key;
1313: END IF;
1314:
1315: -- Debug Message
1316: IF l_debug THEN

Line 1594: delete from AS_EVENT_DATA where event_key = l_event_key;

1590: p_event_name => OPP_LINES_UPDATE_EVENT,
1591: p_event_key => l_event_key,
1592: p_parameters => l_list );
1593: ELSE
1594: delete from AS_EVENT_DATA where event_key = l_event_key;
1595: END IF;
1596:
1597: -- Debug Message
1598: IF l_debug THEN

Line 1844: delete from AS_EVENT_DATA where event_key = l_event_key;

1840: p_event_name => l_event_name,
1841: p_event_key => l_event_key,
1842: p_parameters => l_list );
1843: ELSE
1844: delete from AS_EVENT_DATA where event_key = l_event_key;
1845: END IF;
1846:
1847: -- Debug Message
1848: IF l_debug THEN