APPS.QPR_REPORT_HDRS_PKG dependencies on QPR_REPORT_HDRS_B

Line 22: cursor C is select ROWID from QPR_REPORT_HDRS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from QPR_REPORT_HDRS_B
23: where REPORT_HEADER_ID = X_REPORT_HEADER_ID
24: ;
25: begin
26: insert into QPR_REPORT_HDRS_B (

Line 26: insert into QPR_REPORT_HDRS_B (

22: cursor C is select ROWID from QPR_REPORT_HDRS_B
23: where REPORT_HEADER_ID = X_REPORT_HEADER_ID
24: ;
25: begin
26: insert into QPR_REPORT_HDRS_B (
27: PROGRAM_LOGIN_ID,
28: REQUEST_ID,
29: REPORT_HEADER_ID,
30: REPORT_TYPE_HEADER_ID,

Line 128: from QPR_REPORT_HDRS_B

124: PLAN_ID,
125: SEEDED_REPORT_FLAG,
126: REPORT_VALID_FLAG,
127: ENABLED_OPTIONS
128: from QPR_REPORT_HDRS_B
129: where REPORT_HEADER_ID = X_REPORT_HEADER_ID
130: for update of REPORT_HEADER_ID nowait;
131: recinfo c%rowtype;
132:

Line 207: update QPR_REPORT_HDRS_B set

203: X_LAST_UPDATED_BY in NUMBER,
204: X_LAST_UPDATE_LOGIN in NUMBER
205: ) is
206: begin
207: update QPR_REPORT_HDRS_B set
208: PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
209: REQUEST_ID = X_REQUEST_ID,
210: REPORT_TYPE_HEADER_ID = X_REPORT_TYPE_HEADER_ID,
211: USER_ID = X_USER_ID,

Line 251: delete from QPR_REPORT_HDRS_B

247: if (sql%notfound) then
248: raise no_data_found;
249: end if;
250:
251: delete from QPR_REPORT_HDRS_B
252: where REPORT_HEADER_ID = X_REPORT_HEADER_ID;
253:
254: if (sql%notfound) then
255: raise no_data_found;

Line 265: from QPR_REPORT_HDRS_B B

261: begin
262: delete from QPR_REPORT_HDRS_TL T
263: where not exists
264: (select NULL
265: from QPR_REPORT_HDRS_B B
266: where B.REPORT_HEADER_ID = T.REPORT_HEADER_ID
267: );
268:
269: update QPR_REPORT_HDRS_TL T set (