APPS.QPR_DASHBOARD_MASTER_PKG dependencies on QPR_DASHBOARD_MASTER_B

Line 20: cursor C is select ROWID from QPR_DASHBOARD_MASTER_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from QPR_DASHBOARD_MASTER_B
21: where DASHBOARD_ID = X_DASHBOARD_ID
22: ;
23: begin
24: insert into QPR_DASHBOARD_MASTER_B (

Line 24: insert into QPR_DASHBOARD_MASTER_B (

20: cursor C is select ROWID from QPR_DASHBOARD_MASTER_B
21: where DASHBOARD_ID = X_DASHBOARD_ID
22: ;
23: begin
24: insert into QPR_DASHBOARD_MASTER_B (
25: REQUEST_ID,
26: DASHBOARD_ID,
27: USER_ID,
28: PLAN_ID,

Line 111: from QPR_DASHBOARD_MASTER_B

107: DASHBOARD_TYPE,
108: DEFAULT_FLAG,
109: SOURCE_TEMPLATE_ID,
110: PROGRAM_LOGIN_ID
111: from QPR_DASHBOARD_MASTER_B
112: where DASHBOARD_ID = X_DASHBOARD_ID
113: for update of DASHBOARD_ID nowait;
114: recinfo c%rowtype;
115:

Line 181: update QPR_DASHBOARD_MASTER_B set

177: X_LAST_UPDATED_BY in NUMBER,
178: X_LAST_UPDATE_LOGIN in NUMBER
179: ) is
180: begin
181: update QPR_DASHBOARD_MASTER_B set
182: REQUEST_ID = X_REQUEST_ID,
183: USER_ID = X_USER_ID,
184: PLAN_ID = X_PLAN_ID,
185: DASHBOARD_TYPE = X_DASHBOARD_TYPE,

Line 223: delete from QPR_DASHBOARD_MASTER_B

219: if (sql%notfound) then
220: raise no_data_found;
221: end if;
222:
223: delete from QPR_DASHBOARD_MASTER_B
224: where DASHBOARD_ID = X_DASHBOARD_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 237: from QPR_DASHBOARD_MASTER_B B

233: begin
234: delete from QPR_DASHBOARD_MASTER_TL T
235: where not exists
236: (select NULL
237: from QPR_DASHBOARD_MASTER_B B
238: where B.DASHBOARD_ID = T.DASHBOARD_ID
239: );
240:
241: update QPR_DASHBOARD_MASTER_TL T set (