APPS.QPR_REPORT_TYPE_HDRS_PKG dependencies on QPR_REPORT_TYPE_HDRS_B

Line 19: cursor C is select ROWID from QPR_REPORT_TYPE_HDRS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from QPR_REPORT_TYPE_HDRS_B
20: where REPORT_TYPE_HEADER_ID = X_REPORT_TYPE_HEADER_ID
21: ;
22: begin
23: insert into QPR_REPORT_TYPE_HDRS_B (

Line 23: insert into QPR_REPORT_TYPE_HDRS_B (

19: cursor C is select ROWID from QPR_REPORT_TYPE_HDRS_B
20: where REPORT_TYPE_HEADER_ID = X_REPORT_TYPE_HEADER_ID
21: ;
22: begin
23: insert into QPR_REPORT_TYPE_HDRS_B (
24: REPORT_TYPE_HEADER_ID,
25: REPORT_DOMAIN_CODE,
26: REPORT_LINE_MERGE_CODE,
27: USER_ID,

Line 105: from QPR_REPORT_TYPE_HDRS_B

101: REPORT_LINE_MERGE_CODE,
102: USER_ID,
103: PLAN_ID,
104: REPORT_OPTIONS
105: from QPR_REPORT_TYPE_HDRS_B
106: where REPORT_TYPE_HEADER_ID = X_REPORT_TYPE_HEADER_ID
107: for update of REPORT_TYPE_HEADER_ID nowait;
108: recinfo c%rowtype;
109:

Line 175: update QPR_REPORT_TYPE_HDRS_B set

171: X_LAST_UPDATED_BY in NUMBER,
172: X_LAST_UPDATE_LOGIN in NUMBER
173: ) is
174: begin
175: update QPR_REPORT_TYPE_HDRS_B set
176: REPORT_DOMAIN_CODE = X_REPORT_DOMAIN_CODE,
177: REPORT_LINE_MERGE_CODE = X_REPORT_LINE_MERGE_CODE,
178: USER_ID = X_USER_ID,
179: PLAN_ID = X_PLAN_ID,

Line 216: delete from QPR_REPORT_TYPE_HDRS_B

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: delete from QPR_REPORT_TYPE_HDRS_B
217: where REPORT_TYPE_HEADER_ID = X_REPORT_TYPE_HEADER_ID;
218:
219: if (sql%notfound) then
220: raise no_data_found;

Line 230: from QPR_REPORT_TYPE_HDRS_B B

226: begin
227: delete from QPR_REPORT_TYPE_HDRS_TL T
228: where not exists
229: (select NULL
230: from QPR_REPORT_TYPE_HDRS_B B
231: where B.REPORT_TYPE_HEADER_ID = T.REPORT_TYPE_HEADER_ID
232: );
233:
234: update QPR_REPORT_TYPE_HDRS_TL T set (