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_EXPORT_PVT dependencies on XLA_AAD_GROUP_TBL_TYPE

Line 24: g_aad_groups xla_aad_group_tbl_type;

20:
21: ------------------------------------------------------------------------------
22: -- declaring global variables
23: ------------------------------------------------------------------------------
24: g_aad_groups xla_aad_group_tbl_type;
25:
26: --=============================================================================
27: -- *********** Local Trace Routine **********
28: --=============================================================================

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

832: AND xal.amb_context_code = p_amb_context_code
833: AND xal.product_rule_type_code = p_owner_type
834: AND EXISTS (SELECT 1
835: FROM xla_aad_line_defn_assgns xal2
836: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
837: WHERE xal2.application_id = xal.application_id
838: AND xal2.amb_context_code = xal.amb_context_code
839: AND xal2.event_class_code = xal.event_class_code
840: AND xal2.event_type_code = xal.event_type_code

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

850: AND h.amb_context_code = p_amb_context_code
851: AND h.product_rule_type_code = p_owner_type
852: AND EXISTS (SELECT 1
853: FROM xla_prod_acct_headers pah
854: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
855: WHERE pah.application_id = p_application_id
856: AND pah.amb_context_code = p_amb_context_code
857: AND pah.description_type_code = h.description_type_code
858: AND pah.description_code = h.description_code

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

862: UNION
863: SELECT 1
864: FROM xla_aad_line_defn_assgns xal
865: ,xla_line_defn_jlt_assgns xjl
866: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
867: WHERE xjl.application_id = p_application_id
868: AND xjl.amb_context_code = p_amb_context_code
869: AND xjl.description_type_code = h.description_type_code
870: AND xjl.description_code = h.description_code

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

880: UNION
881: SELECT 1
882: FROM xla_aad_line_defn_assgns xal
883: ,xla_line_defn_jlt_assgns xjl
884: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
885: WHERE xjl.application_id = p_application_id
886: AND xjl.amb_context_code = p_amb_context_code
887: AND xjl.mpa_header_desc_type_code = h.description_type_code
888: AND xjl.mpa_header_desc_code = h.description_code

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

898: UNION
899: SELECT 1
900: FROM xla_aad_line_defn_assgns xal
901: ,xla_mpa_jlt_assgns xjl
902: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
903: WHERE xjl.application_id = p_application_id
904: AND xjl.amb_context_code = p_amb_context_code
905: AND xjl.description_type_code = h.description_type_code
906: AND xjl.description_code = h.description_code

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

927: AND xal.amb_context_code = p_amb_context_code
928: AND xal.product_rule_type_code = p_owner_type
929: AND EXISTS (SELECT 1
930: FROM xla_prod_acct_headers pah
931: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
932: WHERE pah.application_id = p_application_id
933: AND pah.amb_context_code = p_amb_context_code
934: AND pah.description_type_code = h.description_type_code
935: AND pah.description_code = h.description_code

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

939: UNION
940: SELECT 1
941: FROM xla_aad_line_defn_assgns xad
942: ,xla_line_defn_jlt_assgns xjl
943: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
944: WHERE xjl.application_id = p_application_id
945: AND xjl.amb_context_code = p_amb_context_code
946: AND xjl.description_type_code = h.description_type_code
947: AND xjl.description_code = h.description_code

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

957: UNION
958: SELECT 1
959: FROM xla_aad_line_defn_assgns xal
960: ,xla_line_defn_jlt_assgns xjl
961: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
962: WHERE xjl.application_id = p_application_id
963: AND xjl.amb_context_code = p_amb_context_code
964: AND xjl.mpa_header_desc_type_code = h.description_type_code
965: AND xjl.mpa_header_desc_code = h.description_code

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

975: UNION
976: SELECT 1
977: FROM xla_aad_line_defn_assgns xal
978: ,xla_mpa_jlt_assgns xjl
979: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
980: WHERE xjl.application_id = p_application_id
981: AND xjl.amb_context_code = p_amb_context_code
982: AND xjl.description_type_code = h.description_type_code
983: AND xjl.description_code = h.description_code

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

1004: AND xal.amb_context_code = p_amb_context_code
1005: AND xal.product_rule_type_code = p_owner_type
1006: AND EXISTS (SELECT 1
1007: FROM xla_prod_acct_headers pah
1008: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1009: WHERE pah.application_id = p_application_id
1010: AND pah.amb_context_code = p_amb_context_code
1011: AND pah.description_type_code = h.mpa_header_desc_type_code
1012: AND pah.description_code = h.mpa_header_desc_code

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

1016: UNION
1017: SELECT 1
1018: FROM xla_aad_line_defn_assgns xad
1019: ,xla_line_defn_jlt_assgns xjl
1020: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1021: WHERE xjl.application_id = p_application_id
1022: AND xjl.amb_context_code = p_amb_context_code
1023: AND xjl.description_type_code = h.mpa_header_desc_type_code
1024: AND xjl.description_code = h.mpa_header_desc_code

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

1034: UNION
1035: SELECT 1
1036: FROM xla_aad_line_defn_assgns xal
1037: ,xla_line_defn_jlt_assgns xjl
1038: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1039: WHERE xjl.application_id = p_application_id
1040: AND xjl.amb_context_code = p_amb_context_code
1041: AND xjl.mpa_header_desc_type_code = h.mpa_header_desc_type_code
1042: AND xjl.mpa_header_desc_code = h.mpa_header_desc_code

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

1052: UNION
1053: SELECT 1
1054: FROM xla_aad_line_defn_assgns xal
1055: ,xla_mpa_jlt_assgns xjl
1056: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1057: WHERE xjl.application_id = p_application_id
1058: AND xjl.amb_context_code = p_amb_context_code
1059: AND xjl.description_type_code = h.mpa_header_desc_type_code
1060: AND xjl.description_code = h.mpa_header_desc_code

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

1081: AND xal.amb_context_code = p_amb_context_code
1082: AND xal.product_rule_type_code = p_owner_type
1083: AND EXISTS (SELECT 1
1084: FROM xla_prod_acct_headers pah
1085: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1086: WHERE pah.application_id = p_application_id
1087: AND pah.amb_context_code = p_amb_context_code
1088: AND pah.description_type_code = h.description_type_code
1089: AND pah.description_code = h.description_code

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

1093: UNION
1094: SELECT 1
1095: FROM xla_aad_line_defn_assgns xad
1096: ,xla_line_defn_jlt_assgns xjl
1097: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1098: WHERE xjl.application_id = p_application_id
1099: AND xjl.amb_context_code = p_amb_context_code
1100: AND xjl.description_type_code = h.description_type_code
1101: AND xjl.description_code = h.description_code

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

1111: UNION
1112: SELECT 1
1113: FROM xla_aad_line_defn_assgns xal
1114: ,xla_line_defn_jlt_assgns xjl
1115: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1116: WHERE xjl.application_id = p_application_id
1117: AND xjl.amb_context_code = p_amb_context_code
1118: AND xjl.mpa_header_desc_type_code = h.description_type_code
1119: AND xjl.mpa_header_desc_code = h.description_code

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

1129: UNION
1130: SELECT 1
1131: FROM xla_aad_line_defn_assgns xal
1132: ,xla_mpa_jlt_assgns xjl
1133: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1134: WHERE xjl.application_id = p_application_id
1135: AND xjl.amb_context_code = p_amb_context_code
1136: AND xjl.description_type_code = h.description_type_code
1137: AND xjl.description_code = h.description_code

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

1159: AND xal.product_rule_type_code = p_owner_type
1160: AND EXISTS (SELECT 1
1161: FROM xla_aad_line_defn_assgns xad
1162: ,xla_line_defn_jlt_assgns xjl
1163: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1164: WHERE xjl.application_id = p_application_id
1165: AND xjl.amb_context_code = p_amb_context_code
1166: AND xjl.event_class_code = h.event_class_code
1167: AND xjl.accounting_line_type_code = h.accounting_line_type_code

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

1178: UNION
1179: SELECT 1
1180: FROM xla_aad_line_defn_assgns xad
1181: ,xla_mpa_jlt_assgns xjl
1182: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1183: WHERE xjl.application_id = p_application_id
1184: AND xjl.amb_context_code = p_amb_context_code
1185: AND xjl.event_class_code = h.event_class_code
1186: AND xjl.mpa_accounting_line_type_code = h.accounting_line_type_code

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

1209: AND xal.product_rule_type_code = p_owner_type
1210: AND EXISTS (SELECT 1
1211: FROM xla_aad_line_defn_assgns xad
1212: ,xla_line_defn_jlt_assgns xjl
1213: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1214: WHERE xjl.application_id = p_application_id
1215: AND xjl.amb_context_code = p_amb_context_code
1216: AND xjl.event_class_code = h.event_class_code
1217: AND xjl.accounting_line_type_code = h.accounting_line_type_code

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

1228: UNION
1229: SELECT 1
1230: FROM xla_aad_line_defn_assgns xad
1231: ,xla_mpa_jlt_assgns xjl
1232: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1233: WHERE xjl.application_id = p_application_id
1234: AND xjl.amb_context_code = p_amb_context_code
1235: AND xjl.event_class_code = h.event_class_code
1236: AND xjl.mpa_accounting_line_type_code = h.accounting_line_type_code

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

1247:
1248: -- Cursor to return the next AAD that is not grouped
1249: CURSOR c_next_aad IS
1250: SELECT product_rule_code
1251: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type))
1252: WHERE group_num = 0;
1253:
1254: l_aad_group xla_aad_group_rec_type;
1255: l_updated BOOLEAN;

Line 1270: g_aad_groups := xla_aad_group_tbl_type();

1266: ,p_level => C_LEVEL_PROCEDURE
1267: ,p_module => l_log_module);
1268: END IF;
1269:
1270: g_aad_groups := xla_aad_group_tbl_type();
1271:
1272: l_count := 0;
1273:
1274: -- Initialize the AAD array

Line 1440: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

1436: SELECT distinct
1437: grp.product_rule_code
1438: ,grp.version_num version_from
1439: ,(MAX(NVL(h.version_num,0)) OVER (PARTITION BY grp.group_num))+1 version_to
1440: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1441: , xla_aads_h h
1442: WHERE h.application_id(+) = p_application_id
1443: AND h.product_rule_type_code(+) = p_owner_type
1444: AND h.product_rule_code(+) = grp.product_rule_code

Line 1447: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp2

1443: AND h.product_rule_type_code(+) = p_owner_type
1444: AND h.product_rule_code(+) = grp.product_rule_code
1445: AND grp.group_num IN
1446: (SELECT grp2.group_num
1447: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp2
1448: WHERE grp2.updated_flag = 'Y'
1449: OR grp2.leapfrog_flag = 'Y');
1450:
1451: CURSOR c_aad_unchanged IS

Line 1454: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp

1450:
1451: CURSOR c_aad_unchanged IS
1452: SELECT grp.product_rule_code
1453: , max(h.version_num) version_to
1454: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
1455: , xla_aads_h h
1456: WHERE h.application_id = p_application_id
1457: AND h.product_rule_type_code = p_owner_type
1458: AND h.product_rule_code = grp.product_rule_code

Line 1461: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp2

1457: AND h.product_rule_type_code = p_owner_type
1458: AND h.product_rule_code = grp.product_rule_code
1459: AND NOT EXISTS
1460: (SELECT 1
1461: FROM TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp2
1462: WHERE (grp2.updated_flag = 'Y' OR
1463: grp2.leapfrog_flag = 'Y')
1464: AND grp2.group_num = grp.group_num)
1465: GROUP BY grp.product_rule_code;