APPS.QPR_USER_PLAN_INIT_PVT dependencies on QPR_REPORT_HDRS_B

Line 204: * report_header_id in QPR_REPORT_HDRS_B

200: * for user_id=null and plan_id=null
201: */
202: /*
203: * Check for a report entity for that user_id and plan_id and
204: * report_header_id in QPR_REPORT_HDRS_B
205: *Case 1: If one/more record is found,
206: * then update that record's valid_flag='R'
207: *
208: *Case 2: If no record is found, then create a new report header

Line 210: * and insert into QPR_REPORT_HDRS_B/TL tables

206: * then update that record's valid_flag='R'
207: *
208: *Case 2: If no record is found, then create a new report header
209: * record with seeded_report_flag='Y' and report_valid_flag='R'
210: * and insert into QPR_REPORT_HDRS_B/TL tables
211: */
212:
213:
214: insert into QPR_REPORT_HDRS_B

Line 214: insert into QPR_REPORT_HDRS_B

210: * and insert into QPR_REPORT_HDRS_B/TL tables
211: */
212:
213:
214: insert into QPR_REPORT_HDRS_B
215: (
216: REPORT_HEADER_ID
217: ,REPORT_TYPE_HEADER_ID
218: ,USER_ID

Line 256: from QPR_REPORT_HDRS_B rh

252: rth.user_id is null
253: and rth.plan_id is null
254: and not exists
255: ( select 1
256: from QPR_REPORT_HDRS_B rh
257: where rh.user_id = p_user_id
258: and rh.plan_id = p_plan_id
259: and rh.report_type_header_id = rth.report_type_header_id );
260:

Line 293: from QPR_REPORT_HDRS_B RHB,

289: ,null
290: ,null
291: ,null
292: ,null
293: from QPR_REPORT_HDRS_B RHB,
294: qpr_report_type_hdrs_tl RTH,
295: FND_LANGUAGES L,
296: QPR_LOOKUPS QL
297: where L.INSTALLED_FLAG in ('I', 'B')

Line 350: QPR_REPORT_HDRS_B rhb,

346: ,null
347: ,null
348: ,null
349: from
350: QPR_REPORT_HDRS_B rhb,
351: QPR_REPORT_TYPE_ASGN rta,
352: qpr_report_type_lines rtl
353: where
354: rta.report_type_header_id = rhb.report_type_header_id

Line 375: update QPR_REPORT_HDRS_B rh

371: * for the given plan_id, update all report entities
372: * with valid_flag='R'
373: */
374: if (p_user_id is not null) then --{
375: update QPR_REPORT_HDRS_B rh
376: set report_valid_flag = G_REPORT_REFRESH_FLAG
377: where rh.user_id = p_user_id
378: and rh.plan_id = p_plan_id;
379:

Line 389: update QPR_REPORT_HDRS_B rh

385: where rth.user_id = p_user_id
386: and rth.plan_id = p_plan_id
387: );--}
388: else--{
389: update QPR_REPORT_HDRS_B rh
390: set report_valid_flag = G_REPORT_REFRESH_FLAG
391: where rh.plan_id = p_plan_id;
392:
393: update qpr_report_lines rl

Line 397: from QPR_REPORT_HDRS_B rh

393: update qpr_report_lines rl
394: set report_line_valid_flag = G_REPORT_REFRESH_FLAG
395: where rl.report_header_id in
396: (select report_header_id
397: from QPR_REPORT_HDRS_B rh
398: where rh.plan_id = p_plan_id
399: );--}
400: end if;
401: END Reset_report_flags;