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.AD_EVENT_REGISTRY_PKG dependencies on AD_EVENTS

Line 13: Owner ad_events.owner%TYPE,

9: DEFAULT_VERSION CONSTANT NUMBER := 1;
10:
11: -- Event record type is declared here.
12: TYPE Event_Rec_Type IS RECORD(
13: Owner ad_events.owner%TYPE,
14: Event_Name ad_events.event_name%TYPE,
15: Event_Context ad_events.event_context%TYPE,
16: Event_Id ad_events.event_id%TYPE,
17: Event_Status ad_event_versions.status%TYPE,

Line 14: Event_Name ad_events.event_name%TYPE,

10:
11: -- Event record type is declared here.
12: TYPE Event_Rec_Type IS RECORD(
13: Owner ad_events.owner%TYPE,
14: Event_Name ad_events.event_name%TYPE,
15: Event_Context ad_events.event_context%TYPE,
16: Event_Id ad_events.event_id%TYPE,
17: Event_Status ad_event_versions.status%TYPE,
18: -- worker status will be a string indicating status of all the workers

Line 15: Event_Context ad_events.event_context%TYPE,

11: -- Event record type is declared here.
12: TYPE Event_Rec_Type IS RECORD(
13: Owner ad_events.owner%TYPE,
14: Event_Name ad_events.event_name%TYPE,
15: Event_Context ad_events.event_context%TYPE,
16: Event_Id ad_events.event_id%TYPE,
17: Event_Status ad_event_versions.status%TYPE,
18: -- worker status will be a string indicating status of all the workers
19: Worker_Status ad_event_versions.worker_status%TYPE,

Line 16: Event_Id ad_events.event_id%TYPE,

12: TYPE Event_Rec_Type IS RECORD(
13: Owner ad_events.owner%TYPE,
14: Event_Name ad_events.event_name%TYPE,
15: Event_Context ad_events.event_context%TYPE,
16: Event_Id ad_events.event_id%TYPE,
17: Event_Status ad_event_versions.status%TYPE,
18: -- worker status will be a string indicating status of all the workers
19: Worker_Status ad_event_versions.worker_status%TYPE,
20: Event_Version ad_events.last_version%TYPE,

Line 20: Event_Version ad_events.last_version%TYPE,

16: Event_Id ad_events.event_id%TYPE,
17: Event_Status ad_event_versions.status%TYPE,
18: -- worker status will be a string indicating status of all the workers
19: Worker_Status ad_event_versions.worker_status%TYPE,
20: Event_Version ad_events.last_version%TYPE,
21: Event_Type ad_events.event_type%TYPE ,
22: Module_Name ad_event_transitions.module_name%TYPE,
23: Worker_Id ad_event_transitions.worker_id%TYPE,
24: Max_Workers ad_event_versions.num_workers%TYPE );

Line 21: Event_Type ad_events.event_type%TYPE ,

17: Event_Status ad_event_versions.status%TYPE,
18: -- worker status will be a string indicating status of all the workers
19: Worker_Status ad_event_versions.worker_status%TYPE,
20: Event_Version ad_events.last_version%TYPE,
21: Event_Type ad_events.event_type%TYPE ,
22: Module_Name ad_event_transitions.module_name%TYPE,
23: Worker_Id ad_event_transitions.worker_id%TYPE,
24: Max_Workers ad_event_versions.num_workers%TYPE );
25:

Line 252: l_Version ad_events.last_version%TYPE;

248: p_Worker_Id IN NUMBER := NULL ,
249: p_Num_Workers IN NUMBER := NULL )
250: IS
251: -- Local variable declarations
252: l_Version ad_events.last_version%TYPE;
253: l_Event_Id ad_events.event_id%TYPE;
254: l_Event_Type ad_events.event_type%TYPE;
255: l_Event_Status ad_event_versions.status%TYPE;
256: l_Worker_Status_String ad_event_versions.worker_status%TYPE;

Line 253: l_Event_Id ad_events.event_id%TYPE;

249: p_Num_Workers IN NUMBER := NULL )
250: IS
251: -- Local variable declarations
252: l_Version ad_events.last_version%TYPE;
253: l_Event_Id ad_events.event_id%TYPE;
254: l_Event_Type ad_events.event_type%TYPE;
255: l_Event_Status ad_event_versions.status%TYPE;
256: l_Worker_Status_String ad_event_versions.worker_status%TYPE;
257: l_Event_Index NUMBER(3) ;

Line 254: l_Event_Type ad_events.event_type%TYPE;

250: IS
251: -- Local variable declarations
252: l_Version ad_events.last_version%TYPE;
253: l_Event_Id ad_events.event_id%TYPE;
254: l_Event_Type ad_events.event_type%TYPE;
255: l_Event_Status ad_event_versions.status%TYPE;
256: l_Worker_Status_String ad_event_versions.worker_status%TYPE;
257: l_Event_Index NUMBER(3) ;
258: l_Commit_Flag BOOLEAN := FALSE ;

Line 261: l_p_Event_Type ad_events.event_type%TYPE;

257: l_Event_Index NUMBER(3) ;
258: l_Commit_Flag BOOLEAN := FALSE ;
259:
260: -- The following variables will be used to store the IN parameter value
261: l_p_Event_Type ad_events.event_type%TYPE;
262: l_p_Context ad_events.event_context%TYPE ;
263: l_p_Version ad_events.last_version%TYPE;
264:
265: -- The following variable holds the value of number of workers in the last

Line 262: l_p_Context ad_events.event_context%TYPE ;

258: l_Commit_Flag BOOLEAN := FALSE ;
259:
260: -- The following variables will be used to store the IN parameter value
261: l_p_Event_Type ad_events.event_type%TYPE;
262: l_p_Context ad_events.event_context%TYPE ;
263: l_p_Version ad_events.last_version%TYPE;
264:
265: -- The following variable holds the value of number of workers in the last
266: -- call, in case the event fails and restarted this value will be useful.

Line 263: l_p_Version ad_events.last_version%TYPE;

259:
260: -- The following variables will be used to store the IN parameter value
261: l_p_Event_Type ad_events.event_type%TYPE;
262: l_p_Context ad_events.event_context%TYPE ;
263: l_p_Version ad_events.last_version%TYPE;
264:
265: -- The following variable holds the value of number of workers in the last
266: -- call, in case the event fails and restarted this value will be useful.
267: l_Prev_Max_Workers ad_event_versions.num_workers%TYPE ;

Line 303: FROM ad_events

299: event_type
300: INTO l_Version,
301: l_Event_Id,
302: l_Event_Type
303: FROM ad_events
304: WHERE owner = p_Owner
305: AND event_name = p_Event_Name
306: AND event_context = l_p_Context;
307:

Line 356: -- update date are updated in AD_EVENTS

352: INTO l_Event_Status ;
353:
354: --
355: -- If event with lesser version number exists; version and last
356: -- update date are updated in AD_EVENTS
357: --
358: UPDATE ad_events
359: SET last_version = l_p_Version,
360: last_update_date = SYSDATE

Line 358: UPDATE ad_events

354: --
355: -- If event with lesser version number exists; version and last
356: -- update date are updated in AD_EVENTS
357: --
358: UPDATE ad_events
359: SET last_version = l_p_Version,
360: last_update_date = SYSDATE
361: WHERE event_id = l_Event_Id;
362:

Line 391: INSERT INTO ad_events(

387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: -- No Events with the same Owner,Name,Context are registered so far.
390: -- New Event can be registered Now.
391: INSERT INTO ad_events(
392: event_id,
393: owner,
394: event_name,
395: event_context,

Line 401: ad_events_s.NEXTVAL,

397: last_version,
398: creation_date,
399: last_update_date)
400: VALUES(
401: ad_events_s.NEXTVAL,
402: p_Owner,
403: p_Event_Name,
404: l_p_Context,
405: l_p_Event_Type,

Line 554: l_Event_type ad_events.event_type%TYPE;

550: p_Context IN VARCHAR2 := NULL
551: )
552: IS
553: l_Event_Status ad_event_versions.status%TYPE;
554: l_Event_type ad_events.event_type%TYPE;
555: l_Event_Id ad_events.event_id%TYPE;
556: l_Version ad_event_versions.version%TYPE;
557: l_Worker_Id ad_event_transitions.worker_id%TYPE ;
558: l_Worker_Status_String ad_event_versions.worker_status%TYPE ;

Line 555: l_Event_Id ad_events.event_id%TYPE;

551: )
552: IS
553: l_Event_Status ad_event_versions.status%TYPE;
554: l_Event_type ad_events.event_type%TYPE;
555: l_Event_Id ad_events.event_id%TYPE;
556: l_Version ad_event_versions.version%TYPE;
557: l_Worker_Id ad_event_transitions.worker_id%TYPE ;
558: l_Worker_Status_String ad_event_versions.worker_status%TYPE ;
559: l_Module_Name ad_event_transitions.module_name%TYPE ;

Line 562: l_p_Context ad_events.event_context%TYPE ;

558: l_Worker_Status_String ad_event_versions.worker_status%TYPE ;
559: l_Module_Name ad_event_transitions.module_name%TYPE ;
560: l_Event_Index NUMBER ;
561: -- this variable is used to hold in the IN parameter
562: l_p_Context ad_events.event_context%TYPE ;
563: BEGIN
564: --
565: -- The below block checks the value of parameter p_Contect
566: -- if the value is null, it is assumed that the value is default value.

Line 659: l_Event_type ad_events.event_type%TYPE;

655: )
656: IS
657: l_Event_Status ad_event_versions.status%TYPE;
658: l_New_Status ad_event_versions.status%TYPE;
659: l_Event_type ad_events.event_type%TYPE;
660: l_Event_Id ad_events.event_id%TYPE;
661: l_Version ad_event_versions.version%TYPE;
662: l_Worker_Status_String ad_event_versions.worker_status%TYPE;
663: l_End_Time DATE ;

Line 660: l_Event_Id ad_events.event_id%TYPE;

656: IS
657: l_Event_Status ad_event_versions.status%TYPE;
658: l_New_Status ad_event_versions.status%TYPE;
659: l_Event_type ad_events.event_type%TYPE;
660: l_Event_Id ad_events.event_id%TYPE;
661: l_Version ad_event_versions.version%TYPE;
662: l_Worker_Status_String ad_event_versions.worker_status%TYPE;
663: l_End_Time DATE ;
664: l_Max_Workers ad_event_versions.num_workers%TYPE ;

Line 671: l_p_Context ad_events.event_context%TYPE ;

667: -- the following variable stores the index that points to the current
668: -- event's record in the event list
669: l_Event_Index NUMBER ;
670: -- this variable is used to hold in the IN parameter
671: l_p_Context ad_events.event_context%TYPE ;
672:
673: BEGIN -- begin procedure
674: --
675: -- The below block checks the value of parameter p_Contect

Line 708: -- Select the details of the event joining AD_EVENTS and

704: Request_Lock(p_Owner,
705: p_Event_Name);
706:
707: --
708: -- Select the details of the event joining AD_EVENTS and
709: -- AD_EVENT_VERSIONS by joining using the version.
710: --
711:
712: SELECT status,

Line 722: FROM ad_events ae, ad_event_versions av

718: l_Event_type,
719: l_Event_Id,
720: l_Version,
721: l_Worker_Status_String
722: FROM ad_events ae, ad_event_versions av
723: WHERE ae.event_id = av.event_id
724: AND ae.last_version = av.version
725: AND ae.owner = p_Owner
726: AND ae.event_name = p_Event_Name

Line 875: l_p_Context ad_events.event_context%TYPE ;

871: -- Local Variables
872: l_Temp_Var NUMBER ;
873: l_Return_Status BOOLEAN ;
874: -- this variable is used to hold in the IN parameter
875: l_p_Context ad_events.event_context%TYPE ;
876:
877: BEGIN
878: --
879: -- If NULL is passed as the context assume the value to be DEFAULT

Line 895: FROM ad_events ae,

891: -- Else return FALSE
892: --
893: SELECT 1
894: INTO l_Temp_Var
895: FROM ad_events ae,
896: ad_Event_Versions av
897: WHERE ae.owner = p_Owner
898: AND ae.event_name = p_Event_Name
899: AND ae.event_context = l_p_Context

Line 936: l_p_Context ad_events.event_context%TYPE ;

932: l_Num_Workers ad_event_versions.num_workers%TYPE;
933: l_Return_Status BOOLEAN;
934: l_Event_Version ad_event_versions.version%TYPE;
935: -- this variable is used to hold in the IN parameter
936: l_p_Context ad_events.event_context%TYPE ;
937:
938: BEGIN
939: --
940: -- The below block checks the value of parameter p_Contect

Line 958: -- Since the event id is available in AD_EVENTS only AD_EVENTS and

954: END IF ;
955:
956: --
957: -- Select the details of the event based on the input details.
958: -- Since the event id is available in AD_EVENTS only AD_EVENTS and
959: -- AD_EVENT_VERSIONS are joined on this column.
960: -- If a specific version is supplied use that version in the where
961: -- clause otherwise use the last_version column of ad_events.
962: --

Line 961: -- clause otherwise use the last_version column of ad_events.

957: -- Select the details of the event based on the input details.
958: -- Since the event id is available in AD_EVENTS only AD_EVENTS and
959: -- AD_EVENT_VERSIONS are joined on this column.
960: -- If a specific version is supplied use that version in the where
961: -- clause otherwise use the last_version column of ad_events.
962: --
963: SELECT av.status,
964: av.worker_status,
965: av.version,

Line 971: FROM ad_events ae,

967: INTO l_Event_Status,
968: l_Worker_Status_String,
969: l_Event_Version,
970: l_Num_Workers
971: FROM ad_events ae,
972: ad_event_versions av
973: WHERE ae.owner = p_Owner
974: AND ae.event_name = p_Event_Name
975: AND ae.event_context = l_p_Context

Line 1041: l_p_Context ad_events.event_context%TYPE ;

1037: p_Specific_Version IN VARCHAR2 := NULL )
1038: IS
1039: v_Event_Status BOOLEAN ;
1040: -- this variable is used to hold in the IN parameter
1041: l_p_Context ad_events.event_context%TYPE ;
1042: BEGIN
1043: --
1044: -- The below block checks the value of parameter p_Contect
1045: -- if the value is null, it is assumed that the value is default value.

Line 1079: l_p_Context ad_events.event_context%TYPE ;

1075: IS
1076: l_Status ad_event_versions.status%TYPE;
1077: l_Event_Version ad_event_versions.version%TYPE;
1078: -- this variable is used to hold in the IN parameter
1079: l_p_Context ad_events.event_context%TYPE ;
1080: BEGIN
1081: --
1082: -- The below block checks the value of parameter p_Contect
1083: -- if the value is null, it is assumed that the value is default value.

Line 1101: -- Otherwise select the details of the version pointed by AD_EVENTS.

1097:
1098: --
1099: -- Select the details from the db.
1100: -- If a specific version is supplied then select the details foe the same.
1101: -- Otherwise select the details of the version pointed by AD_EVENTS.
1102: --
1103: SELECT av.status,
1104: av.version
1105: INTO l_Status,

Line 1108: ad_events ae,

1104: av.version
1105: INTO l_Status,
1106: l_Event_Version
1107: FROM
1108: ad_events ae,
1109: ad_event_versions av
1110: WHERE ae.owner = p_Owner
1111: AND ae.event_name = p_Event_Name
1112: AND ae.event_context = l_p_Context

Line 1144: l_Event_Type ad_events.event_type%TYPE ;

1140: l_Num_Workers ad_event_versions.num_workers%TYPE;
1141: l_Event_Id ad_event_versions.event_id%TYPE;
1142: l_Version ad_event_versions.version%TYPE;
1143: l_Event_Index NUMBER ;
1144: l_Event_Type ad_events.event_type%TYPE ;
1145: l_Module_Name ad_event_transitions.module_name%TYPE ;
1146: l_Worker_Id ad_event_transitions.worker_id%TYPE ;
1147: -- this variable is used to hold in the IN parameter
1148: l_p_Context ad_events.event_context%TYPE ;

Line 1148: l_p_Context ad_events.event_context%TYPE ;

1144: l_Event_Type ad_events.event_type%TYPE ;
1145: l_Module_Name ad_event_transitions.module_name%TYPE ;
1146: l_Worker_Id ad_event_transitions.worker_id%TYPE ;
1147: -- this variable is used to hold in the IN parameter
1148: l_p_Context ad_events.event_context%TYPE ;
1149: BEGIN
1150: --
1151: -- The below block checks the value of parameter p_Contect
1152: -- if the value is null, it is assumed that the value is default value.

Line 1288: l_p_Context ad_events.event_context%TYPE ;

1284: l_Worker_Id ad_event_transitions.worker_id%TYPE ;
1285: l_Module_Name ad_event_transitions.module_name%TYPE ;
1286: l_Event_Index NUMBER ;
1287: -- this variable is used to hold in the IN parameter
1288: l_p_Context ad_events.event_context%TYPE ;
1289:
1290: BEGIN -- begin procedure
1291: --
1292: -- The below block checks the value of parameter p_Contect

Line 1308: -- Select the event id and the version from AD_EVENTS.

1304: Request_Lock(p_Owner,
1305: p_Event_Name);
1306:
1307: --
1308: -- Select the event id and the version from AD_EVENTS.
1309: --
1310: SELECT ae.event_id,
1311: ae.last_version,
1312: av.status,

Line 1318: FROM ad_events ae, ad_event_versions av

1314: INTO l_Event_Id,
1315: l_Event_Version,
1316: l_Event_Status,
1317: l_Max_Workers
1318: FROM ad_events ae, ad_event_versions av
1319: WHERE ae.owner = p_Owner
1320: AND ae.event_name = p_Event_Name
1321: AND ae.event_context = l_p_Context
1322: AND av.event_id = ae.event_id

Line 1408: l_Event_Id ad_events.event_id%TYPE;

1404: p_Version IN NUMBER := NULL ,
1405: p_Worker_Id IN NUMBER := NULL ,
1406: p_Num_Workers IN NUMBER := NULL )
1407: IS
1408: l_Event_Id ad_events.event_id%TYPE;
1409: l_Event_Version ad_event_versions.version%TYPE ;
1410: l_Event_Status ad_event_versions.status%TYPE ;
1411: l_New_Status ad_event_versions.status%TYPE ;
1412: l_Worker_Status_String ad_event_versions.worker_status%TYPE ;

Line 1419: l_p_Context ad_events.event_context%TYPE ;

1415: l_Prev_Max_Workers ad_event_versions.num_workers%TYPE ;
1416: l_Commit_Flag BOOLEAN ;
1417: l_event_completed_EXP EXCEPTION ;
1418: -- these variables are used to hold in the IN parameter
1419: l_p_Context ad_events.event_context%TYPE ;
1420: l_p_Event_Type ad_events.event_type%TYPE ;
1421: l_p_Version ad_events.last_version%TYPE ;
1422: BEGIN
1423: --

Line 1420: l_p_Event_Type ad_events.event_type%TYPE ;

1416: l_Commit_Flag BOOLEAN ;
1417: l_event_completed_EXP EXCEPTION ;
1418: -- these variables are used to hold in the IN parameter
1419: l_p_Context ad_events.event_context%TYPE ;
1420: l_p_Event_Type ad_events.event_type%TYPE ;
1421: l_p_Version ad_events.last_version%TYPE ;
1422: BEGIN
1423: --
1424: -- The below block checks the value of parameter p_Contect

Line 1421: l_p_Version ad_events.last_version%TYPE ;

1417: l_event_completed_EXP EXCEPTION ;
1418: -- these variables are used to hold in the IN parameter
1419: l_p_Context ad_events.event_context%TYPE ;
1420: l_p_Event_Type ad_events.event_type%TYPE ;
1421: l_p_Version ad_events.last_version%TYPE ;
1422: BEGIN
1423: --
1424: -- The below block checks the value of parameter p_Contect
1425: -- if the value is null, it is assumed that the value is default value.

Line 1459: FROM ad_events ae, ad_event_versions av

1455: l_Event_Id,
1456: l_Worker_Status_String,
1457: l_Prev_Max_Workers,
1458: l_Event_Version
1459: FROM ad_events ae, ad_event_versions av
1460: WHERE ae.event_id = av.event_id
1461: AND ae.last_version = av.version
1462: AND ae.owner = p_Owner
1463: AND ae.event_name = p_Event_Name

Line 1686: UPDATE ad_events

1682: -- greater than the latest version and the event is single-worker.
1683: --
1684: l_Commit_Flag := TRUE ;
1685:
1686: UPDATE ad_events
1687: SET last_version = l_p_Version,
1688: last_update_date = SYSDATE
1689: WHERE event_id = l_Event_Id;
1690:

Line 1726: INSERT INTO ad_events(

1722:
1723: l_Commit_Flag := TRUE ;
1724:
1725: -- For new events control comes here.
1726: INSERT INTO ad_events(
1727: event_id,
1728: owner,
1729: event_name,
1730: event_context,

Line 1736: ad_events_s.NEXTVAL,

1732: last_version,
1733: creation_date,
1734: last_update_date)
1735: VALUES(
1736: ad_events_s.NEXTVAL,
1737: p_Owner,
1738: p_Event_Name,
1739: l_p_Context,
1740: l_p_Event_Type,