APPS.AZ_COMP_REPORTER dependencies on AZ_REPORTER_DATA

Line 116: FROM az_reporter_data

112: hashcode_details
113: INTO v_am_name_a,
114: v_am_disp_name_a,
115: v_hcd_a
116: FROM az_reporter_data
117: WHERE request_id = p_request_id
118: AND source = p_source
119: AND id = 1
120: AND type = -1

Line 146: UPDATE az_reporter_data

142:
143: v_dml_count := v_dml_count + 1;
144: commit_if_required;
145:
146: UPDATE az_reporter_data
147: SET deleted_flag = 'Y'
148: WHERE request_id = p_request_id
149: AND source = p_source
150: AND id = 1

Line 226: FROM az_reporter_data

222: v_children_a_disp_name_list,
223: v_children_a_id_list,
224: v_children_a_hc_list,
225: v_children_a_hcd_list
226: FROM az_reporter_data
227: WHERE request_id = p_request_id
228: AND source = p_source
229: AND parent_id = p_data_pid_a
230: AND is_primary = 'Y';

Line 239: FROM az_reporter_data

235: BEGIN
236: -- get matching VO of B
237: SELECT id
238: INTO v_matching_vo_id_b
239: FROM az_reporter_data
240: WHERE request_id = p_request_id
241: AND source = p_source
242: AND hashcode = v_children_a_hc_list(i)
243: AND parent_id = p_data_pid_b

Line 248: UPDATE az_reporter_data

244: AND is_primary = 'N'
245: AND deleted_flag = 'N'
246: AND rownum = 1;
247:
248: UPDATE az_reporter_data
249: SET deleted_flag = 'Y'
250: WHERE request_id = p_request_id
251: AND source = p_source
252: AND id = v_matching_vo_id_b

Line 289: from az_reporter_data PRIM,az_reporter_data SEC

285: return {$common}{$exprim}{$exsec}' passing
286: PRIM.attributes as "PRIM", SEC.attributes as "SEC"
287: returning content).createSchemaBasedXml(DIFF_SCHEMA_URL)
288: into v_temp_xmltype
289: from az_reporter_data PRIM,az_reporter_data SEC
290: where PRIM.request_id = SEC.request_id
291: and PRIM.source = SEC.source
292: and PRIM.request_id = p_request_id
293: and PRIM.source = p_source

Line 374: FROM az_reporter_data

370: -- children A count > 0
371:
372: SELECT id bulk collect
373: INTO v_children_b_id_list
374: FROM az_reporter_data
375: WHERE request_id = p_request_id
376: AND source = p_source
377: AND parent_id = p_data_pid_b
378: AND is_primary = 'N'

Line 439: FROM az_reporter_data

435: v_disp_name_a,
436: v_id_a,
437: v_hc_a,
438: v_hcd_a
439: FROM az_reporter_data
440: WHERE request_id = p_request_id
441: AND source = p_source
442: AND id = p_data_id
443: AND is_primary = 'Y';

Line 447: FROM az_reporter_data d

443: AND is_primary = 'Y';
444:
445: SELECT d.attributes.transform(v_a_xmltype)
446: INTO v_temp_xmltype
447: FROM az_reporter_data d
448: WHERE request_id = p_request_id
449: AND source = p_source
450: AND id = p_data_id
451: AND is_primary = 'Y';

Line 495: FROM az_reporter_data

491:
492: -- output children
493: SELECT id bulk collect
494: INTO v_children_a_id_list
495: FROM az_reporter_data
496: WHERE request_id = p_request_id
497: AND source = p_source
498: AND parent_id = p_data_id
499: AND is_primary = 'Y';

Line 557: FROM az_reporter_data

553: v_disp_name_b,
554: v_id_b,
555: v_hc_b,
556: v_hcd_b
557: FROM az_reporter_data
558: WHERE request_id = p_request_id
559: AND source = p_source
560: AND id = p_data_id
561: AND is_primary = 'N';

Line 565: FROM az_reporter_data d

561: AND is_primary = 'N';
562:
563: SELECT d.attributes.transform(v_b_xmltype)
564: INTO v_temp_xmltype
565: FROM az_reporter_data d
566: WHERE request_id = p_request_id
567: AND source = p_source
568: AND id = p_data_id
569: AND is_primary = 'N';

Line 608: UPDATE az_reporter_data

604:
605: v_dml_count := v_dml_count + 1;
606: commit_if_required;
607:
608: UPDATE az_reporter_data
609: SET deleted_flag = 'Y'
610: WHERE request_id = p_request_id
611: AND source = p_source
612: AND id = v_id_b

Line 624: FROM az_reporter_data

620:
621: -- output children
622: SELECT id bulk collect
623: INTO v_children_b_id_list
624: FROM az_reporter_data
625: WHERE request_id = p_request_id
626: AND source = p_source
627: AND parent_id = p_data_id
628: AND is_primary = 'N'