APPS.ZX_REPORTING_TYPES_PKG dependencies on ZX_REPORTING_TYPES_B

Line 30: cursor C is select ROWID from ZX_REPORTING_TYPES_B

26: X_PROGRAM_APPLICATION_ID in NUMBER,
27: X_PROGRAM_ID in NUMBER,
28: X_OBJECT_VERSION_NUMBER in NUMBER
29: ) is
30: cursor C is select ROWID from ZX_REPORTING_TYPES_B
31: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID
32: ;
33: begin
34: insert into ZX_REPORTING_TYPES_B (

Line 34: insert into ZX_REPORTING_TYPES_B (

30: cursor C is select ROWID from ZX_REPORTING_TYPES_B
31: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID
32: ;
33: begin
34: insert into ZX_REPORTING_TYPES_B (
35: REQUEST_ID,
36: PROGRAM_LOGIN_ID,
37: REPORTING_TYPE_ID,
38: REPORTING_TYPE_CODE,

Line 154: from ZX_REPORTING_TYPES_B

150: EFFECTIVE_FROM,
151: EFFECTIVE_TO,
152: RECORD_TYPE_CODE,
153: OBJECT_VERSION_NUMBER
154: from ZX_REPORTING_TYPES_B
155: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID
156: for update of REPORTING_TYPE_ID nowait;
157: recinfo c%rowtype;
158:

Line 247: update ZX_REPORTING_TYPES_B set

243: X_PROGRAM_ID in NUMBER,
244: X_OBJECT_VERSION_NUMBER in NUMBER
245: ) is
246: begin
247: update ZX_REPORTING_TYPES_B set
248: REQUEST_ID = X_REQUEST_ID,
249: PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
250: REPORTING_TYPE_CODE = X_REPORTING_TYPE_CODE,
251: REPORTING_TYPE_DATATYPE_CODE = X_REPORTING_TYPE_DATATYPE_CODE,

Line 297: delete from ZX_REPORTING_TYPES_B

293: if (sql%notfound) then
294: raise no_data_found;
295: end if;
296:
297: delete from ZX_REPORTING_TYPES_B
298: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID;
299:
300: if (sql%notfound) then
301: raise no_data_found;

Line 311: from ZX_REPORTING_TYPES_B B

307: begin
308: delete from ZX_REPORTING_TYPES_TL T
309: where not exists
310: (select NULL
311: from ZX_REPORTING_TYPES_B B
312: where B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID
313: );
314:
315: update ZX_REPORTING_TYPES_TL T set (