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.GMF_MIGRATION dependencies on XLA_RULES_T

Line 6854: * Loading XLA_RULES_T GTMP *

6850: l_adr_rule_code := REPLACE( UPPER (SUBSTRB(i.short_name, 1, 14) ||'_'||k.acct_ttl_code||'_'||SUBSTRB(j.short_name, 1, 10)), ' ', '_');
6851: l_adr_rule_name := SUBSTRB(i.name, 1, 20 )||': ('|| k.acct_ttl_code ||') '|| SUBSTRB(k.acct_ttl_desc, 1, 25) ||' For '||SUBSTRB(j.short_name, 1, 10)||' Segment';
6852: xrt := 0;
6853: /********************************
6854: * Loading XLA_RULES_T GTMP *
6855: ********************************/
6856: BEGIN
6857: SELECT count(*)
6858: INTO xrt

Line 6859: FROM xla_rules_t

6855: ********************************/
6856: BEGIN
6857: SELECT count(*)
6858: INTO xrt
6859: FROM xla_rules_t
6860: WHERE application_id = G_Application_id
6861: AND segment_rule_code = l_adr_rule_code
6862: AND amb_context_code = l_amb_context;
6863: EXCEPTION

Line 6868: INSERT INTO xla_rules_t

6864: WHEN no_data_found THEN
6865: xrt := 0;
6866: END;
6867: IF nvl(xrt,0) = 0 THEN
6868: INSERT INTO xla_rules_t
6869: (
6870: APPLICATION_ID,
6871: AMB_CONTEXT_CODE,
6872: SEGMENT_RULE_TYPE_CODE,

Line 7412: * Loading XLA_RULES_T GTMP *

7408: l_adr_rule_code := REPLACE (UPPER (SUBSTRB(i.short_name, 1, 14) ||'_'||k.acct_ttl_code||'_'||SUBSTRB(j.short_name, 1, 10)), ' ', '_');
7409: l_adr_rule_name := SUBSTRB(i.name, 1, 20 )||': ('|| k.acct_ttl_code ||') '|| SUBSTRB(k.acct_ttl_desc, 1, 25) ||' For '||SUBSTRB(j.short_name, 1, 10)||' Segment';
7410: xrt := 0;
7411: /********************************
7412: * Loading XLA_RULES_T GTMP *
7413: ********************************/
7414: BEGIN
7415: SELECT count(*)
7416: INTO xrt

Line 7417: FROM xla_rules_t

7413: ********************************/
7414: BEGIN
7415: SELECT count(*)
7416: INTO xrt
7417: FROM xla_rules_t
7418: WHERE application_id = G_Application_id
7419: AND SEGMENT_RULE_CODE = l_adr_rule_code
7420: AND amb_context_code = l_amb_context;
7421: EXCEPTION

Line 7426: INSERT INTO xla_rules_t

7422: WHEN no_data_found THEN
7423: xrt := 0;
7424: END;
7425: IF nvl(xrt,0) = 0 THEN
7426: INSERT INTO xla_rules_t
7427: (
7428: APPLICATION_ID,
7429: AMB_CONTEXT_CODE,
7430: SEGMENT_RULE_TYPE_CODE,

Line 8488: gmf_migration.G_Table_name := 'XLA_RULES_T';

8484: END IF;
8485: /************************************
8486: * ADR Rules Migration Error Logging *
8487: ************************************/
8488: gmf_migration.G_Table_name := 'XLA_RULES_T';
8489: gmf_migration.G_context := 'GMF Error Logging';
8490: gmf_migration.Log_Errors (
8491: p_log_level => 1,
8492: p_from_rowid => NULL,

Line 12774: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,

12770: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
12771: GROUP BY co_code
12772: HAVING count(*) > 0
12773: ) gl_subr_sta';
12774: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
12775: xla_rules_t.*
12776: FROM (
12777: SELECT ''ALL'' column_name,
12778: ''Unique Constraint Error'' parameters,

Line 12775: xla_rules_t.*

12771: GROUP BY co_code
12772: HAVING count(*) > 0
12773: ) gl_subr_sta';
12774: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
12775: xla_rules_t.*
12776: FROM (
12777: SELECT ''ALL'' column_name,
12778: ''Unique Constraint Error'' parameters,
12779: count(*) records

Line 12780: FROM xla_rules_t

12776: FROM (
12777: SELECT ''ALL'' column_name,
12778: ''Unique Constraint Error'' parameters,
12779: count(*) records
12780: FROM xla_rules_t
12781: WHERE error_value = -1
12782: HAVING count(*) > 0
12783: UNION
12784: SELECT ''ALL'' column_name,

Line 12787: FROM xla_rules_t

12783: UNION
12784: SELECT ''ALL'' column_name,
12785: ''Not Null Constraint'' parameters,
12786: count(*) records
12787: FROM xla_rules_t
12788: WHERE error_value = -1400
12789: HAVING count(*) > 0
12790: UNION
12791: SELECT ''ALL'' column_name,

Line 12794: FROM xla_rules_t

12790: UNION
12791: SELECT ''ALL'' column_name,
12792: ''Invalid Value Error'' parameters,
12793: count(*) records
12794: FROM xla_rules_t
12795: WHERE error_value = -6502
12796: HAVING count(*) > 0
12797: UNION
12798: SELECT ''ALL'' column_name,

Line 12801: FROM xla_rules_t

12797: UNION
12798: SELECT ''ALL'' column_name,
12799: ''Parent-Key Not Found Error'' parameters,
12800: count(*) records
12801: FROM xla_rules_t
12802: WHERE error_value = -2291
12803: HAVING count(*) > 0
12804: UNION
12805: SELECT ''ALL'' column_name,

Line 12808: FROM xla_rules_t

12804: UNION
12805: SELECT ''ALL'' column_name,
12806: ''Value Too Long Error'' parameters,
12807: count(*) records
12808: FROM xla_rules_t
12809: WHERE error_value in (-1438, -12899)
12810: HAVING count(*) > 0
12811: UNION
12812: SELECT ''ALL'' column_name,

Line 12815: FROM xla_rules_t

12811: UNION
12812: SELECT ''ALL'' column_name,
12813: ''Invalid Number Error'' parameters,
12814: count(*) records
12815: FROM xla_rules_t
12816: WHERE error_value = -1722
12817: HAVING count(*) > 0
12818: UNION
12819: SELECT ''ALL'' column_name,

Line 12822: FROM xla_rules_t

12818: UNION
12819: SELECT ''ALL'' column_name,
12820: ''Records not Picked up'' parameters,
12821: count(*) records
12822: FROM xla_rules_t
12823: WHERE error_value = 0
12824: HAVING count(*) > 0
12825: UNION
12826: SELECT ''ALL'' column_name,

Line 12829: FROM xla_rules_t

12825: UNION
12826: SELECT ''ALL'' column_name,
12827: ''Other Errors'' parameters,
12828: count(*) records
12829: FROM xla_rules_t
12830: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12831: HAVING count(*) > 0
12832: ) xla_rules_t';
12833: l_xla_rule_details_t VARCHAR2(32000) := 'SELECT ''XLA_RULE_DETAILS_T'' table_name,

Line 12832: ) xla_rules_t';

12828: count(*) records
12829: FROM xla_rules_t
12830: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12831: HAVING count(*) > 0
12832: ) xla_rules_t';
12833: l_xla_rule_details_t VARCHAR2(32000) := 'SELECT ''XLA_RULE_DETAILS_T'' table_name,
12834: xla_rule_details_t.*
12835: FROM (
12836: SELECT ''ALL'' column_name,

Line 13257: * Migration Error Logging for table XLA_RULES_T *

13253: FROM cm_acst_led;
13254: END IF;
13255: END IF;
13256: /************************************************
13257: * Migration Error Logging for table XLA_RULES_T *
13258: ************************************************/
13259: IF l_table_name IN ('XLA_RULES_T') THEN
13260: IF p_log_level = 1 THEN
13261: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

Line 13259: IF l_table_name IN ('XLA_RULES_T') THEN

13255: END IF;
13256: /************************************************
13257: * Migration Error Logging for table XLA_RULES_T *
13258: ************************************************/
13259: IF l_table_name IN ('XLA_RULES_T') THEN
13260: IF p_log_level = 1 THEN
13261: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13262: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13263: ELSIF p_log_level = 2 THEN

Line 13280: FROM xla_rules_t;

13276: l_too_long_error_count,
13277: l_invalid_number_error_count,
13278: l_not_picked_up_error_count,
13279: l_total_error_count
13280: FROM xla_rules_t;
13281: END IF;
13282: END IF;
13283: /*******************************************************
13284: * Migration Error Logging for table XLA_RULE_DETAILS_T *

Line 13671: ELSIF l_table_name = 'XLA_RULES_T' THEN

13667: ELSIF l_table_name = 'CM_ACST_LED' THEN
13668: OPEN cur_gmf_log_errors FOR l_cm_acst_led;
13669: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13670: CLOSE cur_gmf_log_errors;
13671: ELSIF l_table_name = 'XLA_RULES_T' THEN
13672: OPEN cur_gmf_log_errors FOR l_xla_rules_t;
13673: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13674: CLOSE cur_gmf_log_errors;
13675: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN

Line 13672: OPEN cur_gmf_log_errors FOR l_xla_rules_t;

13668: OPEN cur_gmf_log_errors FOR l_cm_acst_led;
13669: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13670: CLOSE cur_gmf_log_errors;
13671: ELSIF l_table_name = 'XLA_RULES_T' THEN
13672: OPEN cur_gmf_log_errors FOR l_xla_rules_t;
13673: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13674: CLOSE cur_gmf_log_errors;
13675: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN
13676: OPEN cur_gmf_log_errors FOR l_xla_rule_details_t;