DBA Data[Home] [Help]

APPS.OKE_PRINT_FORMS_PKG dependencies on OKE_PRINT_FORMS_B

Line 33: cursor C is select ROWID from OKE_PRINT_FORMS_B

29: , X_ATTRIBUTE13 in VARCHAR2
30: , X_ATTRIBUTE14 in VARCHAR2
31: , X_ATTRIBUTE15 in VARCHAR2
32: ) is
33: cursor C is select ROWID from OKE_PRINT_FORMS_B
34: where PRINT_FORM_CODE = X_PRINT_FORM_CODE
35: ;
36: begin
37: insert into OKE_PRINT_FORMS_B (

Line 37: insert into OKE_PRINT_FORMS_B (

33: cursor C is select ROWID from OKE_PRINT_FORMS_B
34: where PRINT_FORM_CODE = X_PRINT_FORM_CODE
35: ;
36: begin
37: insert into OKE_PRINT_FORMS_B (
38: PRINT_FORM_CODE
39: , CREATION_DATE
40: , CREATED_BY
41: , LAST_UPDATE_DATE

Line 177: from OKE_PRINT_FORMS_B

173: , ATTRIBUTE12
174: , ATTRIBUTE13
175: , ATTRIBUTE14
176: , ATTRIBUTE15
177: from OKE_PRINT_FORMS_B
178: where PRINT_FORM_CODE = X_PRINT_FORM_CODE
179: for update of PRINT_FORM_CODE nowait;
180: recinfo c%rowtype;
181:

Line 294: update OKE_PRINT_FORMS_B set

290: , X_ATTRIBUTE14 in VARCHAR2
291: , X_ATTRIBUTE15 in VARCHAR2
292: ) is
293: begin
294: update OKE_PRINT_FORMS_B set
295: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
296: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
297: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
298: , PRINT_FORM_TYPE_CODE = X_PRINT_FORM_TYPE_CODE

Line 346: from OKE_PRINT_FORMS_B B

342: begin
343: delete from OKE_PRINT_FORMS_TL T
344: where not exists
345: (select NULL
346: from OKE_PRINT_FORMS_B B
347: where B.PRINT_FORM_CODE = T.PRINT_FORM_CODE
348: );
349:
350: update OKE_PRINT_FORMS_TL T set (