APPS.ZX_REPORTING_CODES_PKG dependencies on ZX_REPORTING_CODES_B

Line 25: cursor C is select ROWID from ZX_REPORTING_CODES_B

21: X_LAST_UPDATE_LOGIN in NUMBER,
22: X_PROGRAM_APPLICATION_ID in NUMBER,
23: X_PROGRAM_ID in NUMBER,
24: X_OBJECT_VERSION_NUMBER in NUMBER ) is
25: cursor C is select ROWID from ZX_REPORTING_CODES_B
26: where REPORTING_CODE_ID = X_REPORTING_CODE_ID
27: ;
28: begin
29: insert into ZX_REPORTING_CODES_B (

Line 29: insert into ZX_REPORTING_CODES_B (

25: cursor C is select ROWID from ZX_REPORTING_CODES_B
26: where REPORTING_CODE_ID = X_REPORTING_CODE_ID
27: ;
28: begin
29: insert into ZX_REPORTING_CODES_B (
30: REPORTING_CODE_ID,
31: REPORTING_CODE_CHAR_VALUE,
32: REPORTING_CODE_NUM_VALUE,
33: REPORTING_CODE_DATE_VALUE,

Line 137: from ZX_REPORTING_CODES_B

133: RECORD_TYPE_CODE,
134: REQUEST_ID,
135: PROGRAM_LOGIN_ID,
136: OBJECT_VERSION_NUMBER
137: from ZX_REPORTING_CODES_B
138: where REPORTING_CODE_ID = X_REPORTING_CODE_ID
139: for update of REPORTING_CODE_ID nowait;
140: recinfo c%rowtype;
141:

Line 220: update ZX_REPORTING_CODES_B set

216: X_PROGRAM_ID in NUMBER,
217: X_OBJECT_VERSION_NUMBER in NUMBER
218: ) is
219: begin
220: update ZX_REPORTING_CODES_B set
221: REPORTING_CODE_CHAR_VALUE = X_REPORTING_CODE_CHAR_VALUE,
222: REPORTING_CODE_NUM_VALUE = X_REPORTING_CODE_NUM_VALUE,
223: REPORTING_CODE_DATE_VALUE = X_REPORTING_CODE_DATE_VALUE,
224: REPORTING_TYPE_ID = X_REPORTING_TYPE_ID,

Line 266: delete from ZX_REPORTING_CODES_B

262: if (sql%notfound) then
263: raise no_data_found;
264: end if;
265:
266: delete from ZX_REPORTING_CODES_B
267: where REPORTING_CODE_ID = X_REPORTING_CODE_ID;
268:
269: if (sql%notfound) then
270: raise no_data_found;

Line 280: from ZX_REPORTING_CODES_B B

276: begin
277: delete from ZX_REPORTING_CODES_TL T
278: where not exists
279: (select NULL
280: from ZX_REPORTING_CODES_B B
281: where B.REPORTING_CODE_ID = T.REPORTING_CODE_ID
282: );
283:
284: update ZX_REPORTING_CODES_TL T set (