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 6935: * Loading XLA_RULES_T GTMP *

6931: l_adr_rule_code := REPLACE( UPPER (SUBSTRB(i.short_name, 1, 14) ||'_'||k.acct_ttl_code||'_'||SUBSTRB(j.short_name, 1, 10)), ' ', '_');
6932: 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';
6933: xrt := 0;
6934: /********************************
6935: * Loading XLA_RULES_T GTMP *
6936: ********************************/
6937: BEGIN
6938: SELECT count(*)
6939: INTO xrt

Line 6940: FROM xla_rules_t

6936: ********************************/
6937: BEGIN
6938: SELECT count(*)
6939: INTO xrt
6940: FROM xla_rules_t
6941: WHERE application_id = G_Application_id
6942: AND segment_rule_code = l_adr_rule_code
6943: AND amb_context_code = l_amb_context;
6944: EXCEPTION

Line 6949: INSERT INTO xla_rules_t

6945: WHEN no_data_found THEN
6946: xrt := 0;
6947: END;
6948: IF nvl(xrt,0) = 0 THEN
6949: INSERT INTO xla_rules_t
6950: (
6951: APPLICATION_ID,
6952: AMB_CONTEXT_CODE,
6953: SEGMENT_RULE_TYPE_CODE,

Line 7497: * Loading XLA_RULES_T GTMP *

7493: l_adr_rule_code := REPLACE (UPPER (SUBSTRB(i.short_name, 1, 14) ||'_'||k.acct_ttl_code||'_'||SUBSTRB(j.short_name, 1, 10)), ' ', '_');
7494: 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';
7495: xrt := 0;
7496: /********************************
7497: * Loading XLA_RULES_T GTMP *
7498: ********************************/
7499: BEGIN
7500: SELECT count(*)
7501: INTO xrt

Line 7502: FROM xla_rules_t

7498: ********************************/
7499: BEGIN
7500: SELECT count(*)
7501: INTO xrt
7502: FROM xla_rules_t
7503: WHERE application_id = G_Application_id
7504: AND SEGMENT_RULE_CODE = l_adr_rule_code
7505: AND amb_context_code = l_amb_context;
7506: EXCEPTION

Line 7511: INSERT INTO xla_rules_t

7507: WHEN no_data_found THEN
7508: xrt := 0;
7509: END;
7510: IF nvl(xrt,0) = 0 THEN
7511: INSERT INTO xla_rules_t
7512: (
7513: APPLICATION_ID,
7514: AMB_CONTEXT_CODE,
7515: SEGMENT_RULE_TYPE_CODE,

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

8572: END IF;
8573: /************************************
8574: * ADR Rules Migration Error Logging *
8575: ************************************/
8576: gmf_migration.G_Table_name := 'XLA_RULES_T';
8577: gmf_migration.G_context := 'GMF Error Logging';
8578: gmf_migration.Log_Errors (
8579: p_log_level => 1,
8580: p_from_rowid => NULL,

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

13101: WHERE (cost_type_id IS NULL AND co_code IS NOT NULL)
13102: GROUP BY co_code
13103: HAVING count(*) > 0
13104: ) gl_subr_sta';
13105: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
13106: xla_rules_t.*
13107: FROM (
13108: SELECT ''ALL'' column_name,
13109: ''Unique Constraint Error'' parameters,

Line 13106: xla_rules_t.*

13102: GROUP BY co_code
13103: HAVING count(*) > 0
13104: ) gl_subr_sta';
13105: l_xla_rules_t VARCHAR2(32000) := 'SELECT ''XLA_RULES_T'' table_name,
13106: xla_rules_t.*
13107: FROM (
13108: SELECT ''ALL'' column_name,
13109: ''Unique Constraint Error'' parameters,
13110: count(*) records

Line 13111: FROM xla_rules_t

13107: FROM (
13108: SELECT ''ALL'' column_name,
13109: ''Unique Constraint Error'' parameters,
13110: count(*) records
13111: FROM xla_rules_t
13112: WHERE error_value = -1
13113: HAVING count(*) > 0
13114: UNION
13115: SELECT ''ALL'' column_name,

Line 13118: FROM xla_rules_t

13114: UNION
13115: SELECT ''ALL'' column_name,
13116: ''Not Null Constraint'' parameters,
13117: count(*) records
13118: FROM xla_rules_t
13119: WHERE error_value = -1400
13120: HAVING count(*) > 0
13121: UNION
13122: SELECT ''ALL'' column_name,

Line 13125: FROM xla_rules_t

13121: UNION
13122: SELECT ''ALL'' column_name,
13123: ''Invalid Value Error'' parameters,
13124: count(*) records
13125: FROM xla_rules_t
13126: WHERE error_value = -6502
13127: HAVING count(*) > 0
13128: UNION
13129: SELECT ''ALL'' column_name,

Line 13132: FROM xla_rules_t

13128: UNION
13129: SELECT ''ALL'' column_name,
13130: ''Parent-Key Not Found Error'' parameters,
13131: count(*) records
13132: FROM xla_rules_t
13133: WHERE error_value = -2291
13134: HAVING count(*) > 0
13135: UNION
13136: SELECT ''ALL'' column_name,

Line 13139: FROM xla_rules_t

13135: UNION
13136: SELECT ''ALL'' column_name,
13137: ''Value Too Long Error'' parameters,
13138: count(*) records
13139: FROM xla_rules_t
13140: WHERE error_value in (-1438, -12899)
13141: HAVING count(*) > 0
13142: UNION
13143: SELECT ''ALL'' column_name,

Line 13146: FROM xla_rules_t

13142: UNION
13143: SELECT ''ALL'' column_name,
13144: ''Invalid Number Error'' parameters,
13145: count(*) records
13146: FROM xla_rules_t
13147: WHERE error_value = -1722
13148: HAVING count(*) > 0
13149: UNION
13150: SELECT ''ALL'' column_name,

Line 13153: FROM xla_rules_t

13149: UNION
13150: SELECT ''ALL'' column_name,
13151: ''Records not Picked up'' parameters,
13152: count(*) records
13153: FROM xla_rules_t
13154: WHERE error_value = 0
13155: HAVING count(*) > 0
13156: UNION
13157: SELECT ''ALL'' column_name,

Line 13160: FROM xla_rules_t

13156: UNION
13157: SELECT ''ALL'' column_name,
13158: ''Other Errors'' parameters,
13159: count(*) records
13160: FROM xla_rules_t
13161: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13162: HAVING count(*) > 0
13163: ) xla_rules_t';
13164: l_xla_rule_details_t VARCHAR2(32000) := 'SELECT ''XLA_RULE_DETAILS_T'' table_name,

Line 13163: ) xla_rules_t';

13159: count(*) records
13160: FROM xla_rules_t
13161: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13162: HAVING count(*) > 0
13163: ) xla_rules_t';
13164: l_xla_rule_details_t VARCHAR2(32000) := 'SELECT ''XLA_RULE_DETAILS_T'' table_name,
13165: xla_rule_details_t.*
13166: FROM (
13167: SELECT ''ALL'' column_name,

Line 13588: * Migration Error Logging for table XLA_RULES_T *

13584: FROM cm_acst_led;
13585: END IF;
13586: END IF;
13587: /************************************************
13588: * Migration Error Logging for table XLA_RULES_T *
13589: ************************************************/
13590: IF l_table_name IN ('XLA_RULES_T') THEN
13591: IF p_log_level = 1 THEN
13592: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

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

13586: END IF;
13587: /************************************************
13588: * Migration Error Logging for table XLA_RULES_T *
13589: ************************************************/
13590: IF l_table_name IN ('XLA_RULES_T') THEN
13591: IF p_log_level = 1 THEN
13592: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13593: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13594: ELSIF p_log_level = 2 THEN

Line 13611: FROM xla_rules_t;

13607: l_too_long_error_count,
13608: l_invalid_number_error_count,
13609: l_not_picked_up_error_count,
13610: l_total_error_count
13611: FROM xla_rules_t;
13612: END IF;
13613: END IF;
13614: /*******************************************************
13615: * Migration Error Logging for table XLA_RULE_DETAILS_T *

Line 14002: ELSIF l_table_name = 'XLA_RULES_T' THEN

13998: ELSIF l_table_name = 'CM_ACST_LED' THEN
13999: OPEN cur_gmf_log_errors FOR l_cm_acst_led;
14000: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14001: CLOSE cur_gmf_log_errors;
14002: ELSIF l_table_name = 'XLA_RULES_T' THEN
14003: OPEN cur_gmf_log_errors FOR l_xla_rules_t;
14004: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14005: CLOSE cur_gmf_log_errors;
14006: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN

Line 14003: OPEN cur_gmf_log_errors FOR l_xla_rules_t;

13999: OPEN cur_gmf_log_errors FOR l_cm_acst_led;
14000: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14001: CLOSE cur_gmf_log_errors;
14002: ELSIF l_table_name = 'XLA_RULES_T' THEN
14003: OPEN cur_gmf_log_errors FOR l_xla_rules_t;
14004: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14005: CLOSE cur_gmf_log_errors;
14006: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN
14007: OPEN cur_gmf_log_errors FOR l_xla_rule_details_t;