DBA Data[Home] [Help]

APPS.OKE_K_SECURED_VIEWS_PKG dependencies on AD_DDL

Line 172: AD_DDL.DO_DDL( ApplsysSchema

168: -- ' OR NVL(K.AUTHORING_ORG_ID , -99) = OKE_UTILS.ORG_ID )';
169:
170: Print_Text_Buffer( FND_FILE.OUTPUT , ViewSyntax , TRUE );
171:
172: AD_DDL.DO_DDL( ApplsysSchema
173: , 'OKE'
174: , AD_DDL.CREATE_VIEW
175: , ViewSyntax
176: , SecViewName

Line 174: , AD_DDL.CREATE_VIEW

170: Print_Text_Buffer( FND_FILE.OUTPUT , ViewSyntax , TRUE );
171:
172: AD_DDL.DO_DDL( ApplsysSchema
173: , 'OKE'
174: , AD_DDL.CREATE_VIEW
175: , ViewSyntax
176: , SecViewName
177: );
178:

Line 204: AD_DDL.DO_DDL( ApplsysSchema

200: -- ' OR NVL(K.AUTHORING_ORG_ID , -99) = OKE_UTILS.ORG_ID )';
201:
202: Print_Text_Buffer( FND_FILE.OUTPUT , ViewSyntax , TRUE );
203:
204: AD_DDL.DO_DDL( ApplsysSchema
205: , 'OKE'
206: , AD_DDL.CREATE_VIEW
207: , ViewSyntax
208: , SecViewName

Line 206: , AD_DDL.CREATE_VIEW

202: Print_Text_Buffer( FND_FILE.OUTPUT , ViewSyntax , TRUE );
203:
204: AD_DDL.DO_DDL( ApplsysSchema
205: , 'OKE'
206: , AD_DDL.CREATE_VIEW
207: , ViewSyntax
208: , SecViewName
209: );
210:

Line 223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN

219: FND_MESSAGE.SET_NAME('OKE' , 'OKE_SEC_GEN_VIEW_FAILED');
220: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
224: X_Error_Buf := AD_DDL.Error_Buf;
225: Print_Text_Buffer( FND_FILE.LOG , AD_DDL.Error_Buf , TRUE );
226: ELSE
227: X_Error_Buf := sqlerrm;

Line 224: X_Error_Buf := AD_DDL.Error_Buf;

220: FND_MESSAGE.SET_TOKEN('VIEW' , SecViewName);
221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
224: X_Error_Buf := AD_DDL.Error_Buf;
225: Print_Text_Buffer( FND_FILE.LOG , AD_DDL.Error_Buf , TRUE );
226: ELSE
227: X_Error_Buf := sqlerrm;
228: END IF;

Line 225: Print_Text_Buffer( FND_FILE.LOG , AD_DDL.Error_Buf , TRUE );

221: Print_Text_Buffer( FND_FILE.LOG , FND_MESSAGE.GET , FALSE );
222: Print_Text_Buffer( FND_FILE.LOG , sqlerrm , TRUE );
223: IF ( AD_DDL.ERROR_BUF IS NOT NULL ) THEN
224: X_Error_Buf := AD_DDL.Error_Buf;
225: Print_Text_Buffer( FND_FILE.LOG , AD_DDL.Error_Buf , TRUE );
226: ELSE
227: X_Error_Buf := sqlerrm;
228: END IF;
229: RAISE;