DBA Data[Home] [Help]

APPS.AD_ZD_ADOP dependencies on AD_ZD

Line 1: PACKAGE BODY AD_ZD_ADOP AS

1: PACKAGE BODY AD_ZD_ADOP AS
2: /* $Header: ADZDADOPB.pls 120.25.12020000.39 2013/06/05 11:09:34 mkumandu ship $ */
3:
4: /*API to get the status of applied patch*/
5: PROCEDURE ADOP_PATCH_APPLY_STATUS(adop_sessionID NUMBER, ADOP_tab out

Line 90: | Logging api. This API calls AD_ZD_LOG.Message api. |

86:
87: /*-----------------------------------------------------------------+
88: | |
89: | LOG |
90: | Logging api. This API calls AD_ZD_LOG.Message api. |
91: | |
92: | |
93: +-----------------------------------------------------------------*/
94:

Line 99: AD_ZD_LOG.Message(x_module => pkg_name||'.'||p_module,

95: procedure LOG(p_module varchar2, p_log_type varchar2, p_message varchar2)
96: is
97: begin
98:
99: AD_ZD_LOG.Message(x_module => pkg_name||'.'||p_module,
100: x_log_type => p_log_type,
101: x_message => p_message);
102: end;
103:

Line 602: AD_ZD.EXEC(l_statement,'STATEMENT');

598: FETCH c_sessions_to_kill into l_info,l_statement;
599: while (c_sessions_to_kill%found)
600: loop
601: begin
602: AD_ZD.EXEC(l_statement,'STATEMENT');
603: exception
604: when invalid_session then
605: l_message := 'Invalid user session <'||l_statement||'>';
606: ad_zd_log.message('ADOP','WARNING',l_message);

Line 606: ad_zd_log.message('ADOP','WARNING',l_message);

602: AD_ZD.EXEC(l_statement,'STATEMENT');
603: exception
604: when invalid_session then
605: l_message := 'Invalid user session <'||l_statement||'>';
606: ad_zd_log.message('ADOP','WARNING',l_message);
607: when others then
608: l_message := 'Error: while killing session using <'||l_statement||'> '||sqlerrm;
609: ad_zd_log.message('ADOP','ERROR',l_message);
610: raise_application_error(-20001, l_message);

Line 609: ad_zd_log.message('ADOP','ERROR',l_message);

605: l_message := 'Invalid user session <'||l_statement||'>';
606: ad_zd_log.message('ADOP','WARNING',l_message);
607: when others then
608: l_message := 'Error: while killing session using <'||l_statement||'> '||sqlerrm;
609: ad_zd_log.message('ADOP','ERROR',l_message);
610: raise_application_error(-20001, l_message);
611: end;
612: FETCH c_sessions_to_kill into l_info,l_statement;
613: end loop;

Line 1143: ad_zd.abort(x_mode=>X_MODE);

1139: AND AASP.PATCHRUN_ID IS NOT NULL;
1140:
1141: begin
1142:
1143: ad_zd.abort(x_mode=>X_MODE);
1144: for prid in prids
1145: loop
1146: abort_patch_info(prid.patchrun_id);
1147: end loop;

Line 1152: ad_zd.cutover('QUICK');

1148: end ABORT;
1149:
1150: procedure CUTOVER is
1151: begin
1152: ad_zd.cutover('QUICK');
1153: end CUTOVER;
1154:
1155: procedure FLIP_SNAPSHOTS is
1156: cursor snps is

Line 1727: END AD_ZD_ADOP;

1723: and cutover_status = 'N'
1724: and abort_status='N';
1725: end GET_ACTIV_PATCHING_SES_DETAILS;
1726:
1727: END AD_ZD_ADOP;