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_ZD_ADOP dependencies on AD_ADOP_SESSION_PATCHES

Line 51: 'PATCH_FILE_SYSTEM_BASE,STATUS, NODE_NAME FROM AD_ADOP_SESSION_PATCHES WHERE '||

47: ELSE
48: nodeName := node;
49: END IF;
50: v_str_common := 'Select BUG_NUMBER, APPLIED_FILE_SYSTEM_BASE,'||
51: 'PATCH_FILE_SYSTEM_BASE,STATUS, NODE_NAME FROM AD_ADOP_SESSION_PATCHES WHERE '||
52: 'BUG_NUMBER <> '||''''||'CLONE'||''''||' AND BUG_NUMBER <>' ||
53: ''''||'CONFIG_CLONE'||''''||' AND ADOP_SESSION_ID ='||adop_sessionID;
54: IF (stat = 'ALL' OR stat IS NULL) AND nodeName = 'A' THEN
55: v_str := v_str_common;

Line 118: from ad_adop_session_patches

114: l_first boolean :=true;
115: begin
116: for rec in
117: (select distinct bug_number || ',' as bug_number
118: from ad_adop_session_patches
119: where PATCH_FILE_SYSTEM_BASE is NULL
120: and status = 'Y'
121: order by bug_number )
122: loop

Line 435: select count(1) into l_exists from ad_adop_session_patches

431: else
432: l_ac_status:='N';
433: end if;
434:
435: select count(1) into l_exists from ad_adop_session_patches
436: where ADOP_SESSION_ID=p_session_id and BUG_NUMBER=p_bug_number and
437: APPLIED_FILE_SYSTEM_BASE=p_appltop_base and APPLTOP_ID=rec.appl_top_id and
438: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;
439:

Line 441: select STATUS into l_current_status from ad_adop_session_patches

437: APPLIED_FILE_SYSTEM_BASE=p_appltop_base and APPLTOP_ID=rec.appl_top_id and
438: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;
439:
440: if (l_exists > 0) then
441: select STATUS into l_current_status from ad_adop_session_patches
442: where ADOP_SESSION_ID=p_session_id and BUG_NUMBER=p_bug_number and
443: APPLIED_FILE_SYSTEM_BASE=p_appltop_base and APPLTOP_ID=rec.appl_top_id and
444: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;
445:

Line 447: log(l_mod_name,'STATEMENTC','Updating existing AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);

443: APPLIED_FILE_SYSTEM_BASE=p_appltop_base and APPLTOP_ID=rec.appl_top_id and
444: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;
445:
446: if (status_order(l_current_status) < status_order(l_status)) then
447: log(l_mod_name,'STATEMENTC','Updating existing AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);
448: log(l_mod_name,'STATEMENT','- STATUS: ' || l_current_status || ' -> ' || l_status);
449:
450: update ad_adop_session_patches
451: set PATCHRUN_ID=p_patch_run_id, STATUS=l_status, AUTOCONFIG_STATUS=l_ac_status,

Line 450: update ad_adop_session_patches

446: if (status_order(l_current_status) < status_order(l_status)) then
447: log(l_mod_name,'STATEMENTC','Updating existing AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);
448: log(l_mod_name,'STATEMENT','- STATUS: ' || l_current_status || ' -> ' || l_status);
449:
450: update ad_adop_session_patches
451: set PATCHRUN_ID=p_patch_run_id, STATUS=l_status, AUTOCONFIG_STATUS=l_ac_status,
452: START_DATE=p_start_date, END_DATE=p_end_date
453: where ADOP_SESSION_ID=p_session_id and BUG_NUMBER=p_bug_number and APPLTOP_ID=rec.appl_top_id and
454: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;

Line 457: log(l_mod_name,'STATEMENT','Inserting new AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);

453: where ADOP_SESSION_ID=p_session_id and BUG_NUMBER=p_bug_number and APPLTOP_ID=rec.appl_top_id and
454: NODE_NAME=rec.node_name and DRIVER_FILE_NAME=p_driverfile_name;
455: end if;
456: else
457: log(l_mod_name,'STATEMENT','Inserting new AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);
458:
459: INSERT INTO ad_adop_session_patches
460: (ADOP_SESSION_ID, BUG_NUMBER, PATCHRUN_ID, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE,
461: ADPATCH_OPTIONS, APPLTOP_ID, NODE_NAME, AUTOCONFIG_STATUS, START_DATE, END_DATE, PATCH_TOP, DRIVER_FILE_NAME)

Line 459: INSERT INTO ad_adop_session_patches

455: end if;
456: else
457: log(l_mod_name,'STATEMENT','Inserting new AD_ADOP_SESSION_PATCHES table entry for patch #' || p_bug_number);
458:
459: INSERT INTO ad_adop_session_patches
460: (ADOP_SESSION_ID, BUG_NUMBER, PATCHRUN_ID, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE,
461: ADPATCH_OPTIONS, APPLTOP_ID, NODE_NAME, AUTOCONFIG_STATUS, START_DATE, END_DATE, PATCH_TOP, DRIVER_FILE_NAME)
462: VALUES
463: (p_session_id, p_bug_number, p_patch_run_id, l_status, p_appltop_base, NULL, p_adpatch_options,

Line 656: select count(*) into l_is_locked from ad_adop_session_patches where adop_session_id=0 and BUG_NUMBER=p_lock_name;

652: pragma exception_init(resource_busy,-54);
653: l_is_locked number:=0;
654: begin
655: begin
656: select count(*) into l_is_locked from ad_adop_session_patches where adop_session_id=0 and BUG_NUMBER=p_lock_name;
657: if (l_is_locked = 0) then
658: lock table ad_adop_session_patches in exclusive mode nowait;
659: insert into ad_adop_session_patches
660: (ADOP_SESSION_ID,BUG_NUMBER,STATUS,NODE_NAME)

Line 658: lock table ad_adop_session_patches in exclusive mode nowait;

654: begin
655: begin
656: select count(*) into l_is_locked from ad_adop_session_patches where adop_session_id=0 and BUG_NUMBER=p_lock_name;
657: if (l_is_locked = 0) then
658: lock table ad_adop_session_patches in exclusive mode nowait;
659: insert into ad_adop_session_patches
660: (ADOP_SESSION_ID,BUG_NUMBER,STATUS,NODE_NAME)
661: values (0,p_lock_name,'N',p_node_name);
662: commit;

Line 659: insert into ad_adop_session_patches

655: begin
656: select count(*) into l_is_locked from ad_adop_session_patches where adop_session_id=0 and BUG_NUMBER=p_lock_name;
657: if (l_is_locked = 0) then
658: lock table ad_adop_session_patches in exclusive mode nowait;
659: insert into ad_adop_session_patches
660: (ADOP_SESSION_ID,BUG_NUMBER,STATUS,NODE_NAME)
661: values (0,p_lock_name,'N',p_node_name);
662: commit;
663: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');

Line 663: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');

659: insert into ad_adop_session_patches
660: (ADOP_SESSION_ID,BUG_NUMBER,STATUS,NODE_NAME)
661: values (0,p_lock_name,'N',p_node_name);
662: commit;
663: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');
664: return;
665: else
666: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
667: commit;

Line 666: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');

662: commit;
663: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');
664: return;
665: else
666: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
667: commit;
668: end if;
669: exception
670: when resource_busy then

Line 671: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');

667: commit;
668: end if;
669: exception
670: when resource_busy then
671: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
672: end;
673: end LOCK_PATCHES_TABLE;
674:
675: PROCEDURE UNLOCK_PATCHES_TABLE(p_node_name in varchar2,p_lock_name in varchar2) is

Line 682: select count(1) into l_is_locked from ad_adop_session_patches

678: pragma exception_init(resource_busy,-54);
679: l_is_locked number:=0;
680: begin
681: begin
682: select count(1) into l_is_locked from ad_adop_session_patches
683: where adop_session_id=0 and BUG_NUMBER=p_lock_name
684: and node_name=p_node_name;
685: if (l_is_locked <> 0) then
686: lock table ad_adop_session_patches in exclusive mode nowait;

Line 686: lock table ad_adop_session_patches in exclusive mode nowait;

682: select count(1) into l_is_locked from ad_adop_session_patches
683: where adop_session_id=0 and BUG_NUMBER=p_lock_name
684: and node_name=p_node_name;
685: if (l_is_locked <> 0) then
686: lock table ad_adop_session_patches in exclusive mode nowait;
687: delete from ad_adop_session_patches
688: where adop_session_id=0 and BUG_NUMBER=p_lock_name
689: and node_name=p_node_name;
690: commit;

Line 687: delete from ad_adop_session_patches

683: where adop_session_id=0 and BUG_NUMBER=p_lock_name
684: and node_name=p_node_name;
685: if (l_is_locked <> 0) then
686: lock table ad_adop_session_patches in exclusive mode nowait;
687: delete from ad_adop_session_patches
688: where adop_session_id=0 and BUG_NUMBER=p_lock_name
689: and node_name=p_node_name;
690: commit;
691: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');

Line 691: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');

687: delete from ad_adop_session_patches
688: where adop_session_id=0 and BUG_NUMBER=p_lock_name
689: and node_name=p_node_name;
690: commit;
691: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');
692: return;
693: else
694: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
695: commit;

Line 694: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');

690: commit;
691: log(l_mod_name, 'STATEMENT', 'Able to acquire lock on ad_adop_session_patches table.');
692: return;
693: else
694: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
695: commit;
696: return;
697: end if;
698: exception

Line 700: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');

696: return;
697: end if;
698: exception
699: when resource_busy then
700: log(l_mod_name, 'WARNING', 'Unable to acquire lock on ad_adop_session_patches table.');
701: end;
702: end UNLOCK_PATCHES_TABLE;
703:
704: PROCEDURE SYNC_SNAPSHOTS(p_appl_top_id in number default null)

Line 1129: FROM AD_ADOP_SESSION_PATCHES AASP

1125:
1126: procedure ABORT(X_MODE in varchar2 default null, X_SESSION_ID in number) is
1127: cursor prids is
1128: SELECT AASP.PATCHRUN_ID
1129: FROM AD_ADOP_SESSION_PATCHES AASP
1130: WHERE AASP.ADOP_SESSION_ID=x_session_id
1131: AND AASP.PATCHRUN_ID IS NOT NULL
1132: UNION
1133: SELECT ACFH.PATCH_RUN_ID

Line 1135: AD_ADOP_SESSION_PATCHES aasp

1131: AND AASP.PATCHRUN_ID IS NOT NULL
1132: UNION
1133: SELECT ACFH.PATCH_RUN_ID
1134: FROM AD_CHECK_FILE_HISTORY ACFH,
1135: AD_ADOP_SESSION_PATCHES aasp
1136: WHERE ACFH.PATCH_RUN_ID>AASP.PATCHRUN_ID
1137: AND AASP.ADOP_SESSION_ID=x_session_id
1138: AND AASP.PATCHRUN_ID<>-1
1139: AND AASP.PATCHRUN_ID IS NOT NULL;

Line 1349: from ad_adop_session_patches

1345: and fpg.aru_release_name=ar.aru_release_name
1346: and aat.name=EXTRACTVALUE(XMLType(focf.TEXT),'//APPL_TOP_NAME');
1347:
1348: select count(1) into l_clone_exists
1349: from ad_adop_session_patches
1350: where APPLTOP_ID=l_appl_top_id and node_name=node.host
1351: and bug_number='CLONE' and status='N'
1352: and clone_status='NOT-STARTED';
1353:

Line 1356: insert into ad_adop_session_patches(ADOP_SESSION_ID, BUG_NUMBER, STATUS,

1352: and clone_status='NOT-STARTED';
1353:
1354: if (l_clone_exists = 0)
1355: then
1356: insert into ad_adop_session_patches(ADOP_SESSION_ID, BUG_NUMBER, STATUS,
1357: APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, APPLTOP_ID,
1358: NODE_NAME, AUTOCONFIG_STATUS, START_DATE, CLONE_STATUS)
1359: values (l_adop_session_id, 'CLONE', 'N', p_run_base, p_patch_base,
1360: l_appl_top_id, node.host, 'N', sysdate, 'NOT-STARTED');