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 = p_request_id and PRIM.source = p_source
291: and PRIM.id=v_children_A_ID_List(i) and PRIM.is_primary='Y'
292: and SEC.request_id = p_request_id and SEC.source = p_source
293: and SEC.id = v_matching_VO_id_B

Line 370: FROM az_reporter_data

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

Line 435: FROM az_reporter_data

431: v_disp_name_a,
432: v_id_a,
433: v_hc_a,
434: v_hcd_a
435: FROM az_reporter_data
436: WHERE request_id = p_request_id
437: AND source = p_source
438: AND id = p_data_id
439: AND is_primary = 'Y';

Line 443: FROM az_reporter_data d

439: AND is_primary = 'Y';
440:
441: SELECT d.attributes.transform(v_a_xmltype)
442: INTO v_temp_xmltype
443: FROM az_reporter_data d
444: WHERE request_id = p_request_id
445: AND source = p_source
446: AND id = p_data_id
447: AND is_primary = 'Y';

Line 491: FROM az_reporter_data

487:
488: -- output children
489: SELECT id bulk collect
490: INTO v_children_a_id_list
491: FROM az_reporter_data
492: WHERE request_id = p_request_id
493: AND source = p_source
494: AND parent_id = p_data_id
495: AND is_primary = 'Y';

Line 553: FROM az_reporter_data

549: v_disp_name_b,
550: v_id_b,
551: v_hc_b,
552: v_hcd_b
553: FROM az_reporter_data
554: WHERE request_id = p_request_id
555: AND source = p_source
556: AND id = p_data_id
557: AND is_primary = 'N';

Line 561: FROM az_reporter_data d

557: AND is_primary = 'N';
558:
559: SELECT d.attributes.transform(v_b_xmltype)
560: INTO v_temp_xmltype
561: FROM az_reporter_data d
562: WHERE request_id = p_request_id
563: AND source = p_source
564: AND id = p_data_id
565: AND is_primary = 'N';

Line 604: UPDATE az_reporter_data

600:
601: v_dml_count := v_dml_count + 1;
602: commit_if_required;
603:
604: UPDATE az_reporter_data
605: SET deleted_flag = 'Y'
606: WHERE request_id = p_request_id
607: AND source = p_source
608: AND id = v_id_b

Line 620: FROM az_reporter_data

616:
617: -- output children
618: SELECT id bulk collect
619: INTO v_children_b_id_list
620: FROM az_reporter_data
621: WHERE request_id = p_request_id
622: AND source = p_source
623: AND parent_id = p_data_id
624: AND is_primary = 'N'