eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_AAD_GROUP_TBL_TYPE

Line 52: g_aad_groups xla_aad_group_tbl_type;

48: g_application_id NUMBER;
49: g_amb_context_code VARCHAR2(30);
50: g_staging_context_code VARCHAR2(30);
51: g_batch_name VARCHAR2(30);
52: g_aad_groups xla_aad_group_tbl_type;
53: g_user_mode VARCHAR2(30);
54:
55: g_assgns AssgnIndex;
56: g_num_updated_props INTEGER;

Line 8691: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8687: WHERE h.application_id = g_application_id
8688: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8689: AND EXISTS (SELECT 1
8690: FROM xla_prod_acct_headers pah
8691: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8692: WHERE pah.application_id = g_application_id
8693: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8694: AND pah.description_type_code = h.description_type_code
8695: AND pah.description_code = h.description_code

Line 8703: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8699: UNION
8700: SELECT 1
8701: FROM xla_aad_line_defn_assgns xal
8702: ,xla_line_defn_jlt_assgns xjl
8703: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8704: WHERE xjl.application_id = g_application_id
8705: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8706: AND xjl.description_type_code = h.description_type_code
8707: AND xjl.description_code = h.description_code

Line 8731: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8727: AND h.application_id = g_application_id
8728: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8729: AND EXISTS (SELECT 1
8730: FROM xla_prod_acct_headers pah
8731: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8732: WHERE pah.application_id = g_application_id
8733: AND pah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8734: AND pah.description_type_code = h.description_type_code
8735: AND pah.description_code = h.description_code

Line 8743: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8739: UNION
8740: SELECT 1
8741: FROM xla_aad_line_defn_assgns xal
8742: ,xla_line_defn_jlt_assgns xjl
8743: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8744: WHERE xjl.application_id = g_application_id
8745: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8746: AND xjl.description_type_code = h.description_type_code
8747: AND xjl.description_code = h.description_code

Line 8772: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8768: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8769: AND EXISTS (SELECT 1
8770: FROM xla_aad_line_defn_assgns xad
8771: ,xla_line_defn_jlt_assgns xjl
8772: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8773: WHERE xjl.application_id = g_application_id
8774: AND xjl.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8775: AND xjl.event_class_code = h.event_class_code
8776: AND xjl.accounting_line_type_code = h.accounting_line_type_code

Line 8794: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8790: WHERE h.application_id = g_application_id
8791: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8792: AND EXISTS (SELECT 1
8793: FROM xla_aad_header_ac_assgns xah
8794: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8795: WHERE xah.analytical_criterion_type_code = h.analytical_criterion_type_code
8796: AND xah.analytical_criterion_code = h.analytical_criterion_code
8797: AND xah.application_id = g_application_id
8798: AND xah.amb_context_code IN (g_amb_context_code,g_staging_context_code)

Line 8806: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8802: UNION
8803: SELECT 1
8804: FROM xla_line_defn_ac_assgns xac
8805: ,xla_aad_line_defn_assgns xal
8806: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8807: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8808: AND xac.analytical_criterion_code = h.analytical_criterion_code
8809: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8810: AND xac.application_id = g_application_id

Line 8834: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8830: AND xad.application_id = g_application_id
8831: AND xad.amb_context_code = g_amb_context_code
8832: AND EXISTS (SELECT 1
8833: FROM xla_aad_header_ac_assgns xah
8834: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8835: WHERE xah.analytical_criterion_type_code = h.analytical_criterion_type_code
8836: AND xah.analytical_criterion_code = h.analytical_criterion_code
8837: AND xah.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8838: AND xah.application_id = g_application_id

Line 8846: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8842: UNION
8843: SELECT 1
8844: FROM xla_line_defn_ac_assgns xac
8845: ,xla_aad_line_defn_assgns xal
8846: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8847: WHERE xac.analytical_criterion_type_code = h.analytical_criterion_type_code
8848: AND xac.analytical_criterion_code = h.analytical_criterion_code
8849: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8850: AND xac.application_id = g_application_id

Line 8875: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8871: AND h.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8872: AND EXISTS (SELECT 1
8873: FROM xla_line_defn_adr_assgns xac
8874: ,xla_aad_line_defn_assgns xal
8875: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8876: WHERE xac.application_id = g_application_id
8877: AND xac.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8878: AND xac.segment_rule_type_code = h.segment_rule_type_code
8879: AND xac.segment_rule_code = h.segment_rule_code

Line 8910: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

8906: AND EXISTS (SELECT 1
8907: FROM xla_line_defn_adr_assgns adr2
8908: ,xla_aad_line_defn_assgns xal2
8909: ,xla_seg_rule_details xsr2
8910: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8911: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code
8912: AND xsr2.application_id = adr2.application_id
8913: AND xsr2.amb_context_code = adr2.amb_context_code
8914: AND xsr2.segment_rule_type_code = adr2.segment_rule_type_code

Line 8931: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type))

8927:
8928: -- Cursor to return the next AAD that is not grouped
8929: CURSOR c_next_aad IS
8930: SELECT product_rule_type_code, product_rule_code
8931: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type))
8932: WHERE group_num = 0;
8933:
8934: l_aad_group xla_aad_group_rec_type;
8935: l_updated BOOLEAN;

Line 8951: g_aad_groups := xla_aad_group_tbl_type();

8947: ,p_level => C_LEVEL_PROCEDURE
8948: ,p_module => l_log_module);
8949: END IF;
8950:
8951: g_aad_groups := xla_aad_group_tbl_type();
8952:
8953: l_count := 0;
8954: l_curr_group_num := 1;
8955: