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_RULE_DETAILS_T

Line 6984: FROM xla_rule_details_t

6980: ELSE
6981: BEGIN
6982: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
6983: INTO l_adr_priority
6984: FROM xla_rule_details_t
6985: WHERE application_id = G_Application_id
6986: AND segment_rule_code = l_adr_rule_code
6987: AND amb_context_code = l_amb_context;
6988: EXCEPTION

Line 7062: * Loading XLA_RULE_DETAILS_T Structure *

7058: ELSE
7059: l_segment_value := l.acctg_unit_no ; /*Bug 9660507 - When only one AU segment is available, use the value directly*/
7060: END IF;
7061: /***************************************
7062: * Loading XLA_RULE_DETAILS_T Structure *
7063: ***************************************/
7064: BEGIN
7065: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7066: INTO l_adr_priority

Line 7067: FROM xla_rule_details_t

7063: ***************************************/
7064: BEGIN
7065: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7066: INTO l_adr_priority
7067: FROM xla_rule_details_t
7068: WHERE application_id = G_Application_id
7069: AND segment_rule_code = l_adr_rule_code
7070: AND amb_context_code = l_amb_context;
7071: EXCEPTION

Line 7076: INSERT INTO xla_rule_details_t

7072: WHEN no_data_found THEN
7073: l_adr_priority := 10;
7074: END;
7075: l_segment_rule_detail_id := NULL;
7076: INSERT INTO xla_rule_details_t
7077: (
7078: APPLICATION_ID,
7079: AMB_CONTEXT_CODE,
7080: SEGMENT_RULE_TYPE_CODE,

Line 7211: FROM xla_rule_details_t

7207: IF mcnt > 1 THEN
7208: BEGIN
7209: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7210: INTO l_adr_priority
7211: FROM xla_rule_details_t
7212: WHERE application_id = G_Application_id
7213: AND segment_rule_code = l_adr_rule_code
7214: AND amb_context_code = l_amb_context;
7215: EXCEPTION

Line 7220: INSERT INTO xla_rule_details_t

7216: WHEN no_data_found THEN
7217: l_adr_priority := 10;
7218: END;
7219: l_segment_rule_detail_id := NULL;
7220: INSERT INTO xla_rule_details_t
7221: (
7222: APPLICATION_ID,
7223: AMB_CONTEXT_CODE,
7224: SEGMENT_RULE_TYPE_CODE,

Line 7350: FROM xla_rule_details_t

7346: IF NVL(l.inventory_org_ind,'N') = 'Y' AND nvl(mcnt, 1) > 1 THEN
7347: BEGIN
7348: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7349: INTO l_adr_priority
7350: FROM xla_rule_details_t
7351: WHERE application_id = G_Application_id
7352: AND segment_rule_code = l_adr_rule_code
7353: AND amb_context_code = l_amb_context;
7354: EXCEPTION

Line 7359: INSERT INTO xla_rule_details_t

7355: WHEN no_data_found THEN
7356: l_adr_priority := 10;
7357: END;
7358: l_segment_rule_detail_id := NULL;
7359: INSERT INTO xla_rule_details_t
7360: (
7361: APPLICATION_ID,
7362: AMB_CONTEXT_CODE,
7363: SEGMENT_RULE_TYPE_CODE,

Line 7546: FROM xla_rule_details_t

7542: ELSE
7543: BEGIN
7544: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7545: INTO l_adr_priority
7546: FROM xla_rule_details_t
7547: WHERE application_id = G_Application_id
7548: AND segment_rule_code = l_adr_rule_code
7549: AND amb_context_code = l_amb_context;
7550: EXCEPTION

Line 7852: * Loading XLA_RULE_DETAILS_T Structure *

7848: i.segment_delimiter c
7849: FROM dual
7850: );
7851: /***************************************
7852: * Loading XLA_RULE_DETAILS_T Structure *
7853: ***************************************/
7854: BEGIN
7855: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
7856: INTO l_adr_priority

Line 7857: FROM xla_rule_details_t

7853: ***************************************/
7854: BEGIN
7855: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
7856: INTO l_adr_priority
7857: FROM xla_rule_details_t
7858: WHERE application_id = G_Application_id
7859: AND segment_rule_code = l_adr_rule_code
7860: AND amb_context_code = l_amb_context;
7861: EXCEPTION

Line 7866: INSERT INTO xla_rule_details_t

7862: WHEN no_data_found THEN
7863: l_adr_priority := 10;
7864: END;
7865: l_segment_rule_detail_id := NULL;
7866: INSERT INTO xla_rule_details_t
7867: (
7868: APPLICATION_ID,
7869: AMB_CONTEXT_CODE,
7870: SEGMENT_RULE_TYPE_CODE,

Line 8225: FROM xla_rule_details_t

8221: IF mcnt > 1 THEN
8222: BEGIN
8223: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
8224: INTO l_adr_priority
8225: FROM xla_rule_details_t
8226: WHERE application_id = G_Application_id
8227: AND segment_rule_code = l_adr_rule_code
8228: AND amb_context_code = l_amb_context;
8229: EXCEPTION

Line 8233: INSERT INTO xla_rule_details_t

8229: EXCEPTION
8230: WHEN no_data_found THEN
8231: l_adr_priority := 10;
8232: END;
8233: INSERT INTO xla_rule_details_t
8234: (
8235: APPLICATION_ID,
8236: AMB_CONTEXT_CODE,
8237: SEGMENT_RULE_TYPE_CODE,

Line 8382: FROM xla_rule_details_t

8378: IF NVL(l_inventory_org_ind(m),'N') = 'Y' AND nvl(mcnt, 1) > 1 THEN
8379: BEGIN
8380: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
8381: INTO l_adr_priority
8382: FROM xla_rule_details_t
8383: WHERE application_id = G_Application_id
8384: AND segment_rule_code = l_adr_rule_code
8385: AND amb_context_code = l_amb_context;
8386: EXCEPTION

Line 8391: INSERT INTO xla_rule_details_t

8387: WHEN no_data_found THEN
8388: l_adr_priority := 10;
8389: END;
8390: l_segment_rule_detail_id := NULL;
8391: INSERT INTO xla_rule_details_t
8392: (
8393: APPLICATION_ID,
8394: AMB_CONTEXT_CODE,
8395: SEGMENT_RULE_TYPE_CODE,

Line 8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';

8582: );
8583: /*******************************************
8584: * ADR Rule Details Migration Error Logging *
8585: *******************************************/
8586: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8587: gmf_migration.G_context := 'GMF Error Logging';
8588: gmf_migration.Log_Errors (
8589: p_log_level => 1,
8590: p_from_rowid => NULL,

Line 13164: l_xla_rule_details_t VARCHAR2(32000) := 'SELECT ''XLA_RULE_DETAILS_T'' table_name,

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,
13168: ''Unique Constraint Error'' parameters,

Line 13165: xla_rule_details_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,
13168: ''Unique Constraint Error'' parameters,
13169: count(*) records

Line 13170: FROM xla_rule_details_t

13166: FROM (
13167: SELECT ''ALL'' column_name,
13168: ''Unique Constraint Error'' parameters,
13169: count(*) records
13170: FROM xla_rule_details_t
13171: WHERE error_value = -1
13172: HAVING count(*) > 0
13173: UNION
13174: SELECT ''ALL'' column_name,

Line 13177: FROM xla_rule_details_t

13173: UNION
13174: SELECT ''ALL'' column_name,
13175: ''Not Null Constraint'' parameters,
13176: count(*) records
13177: FROM xla_rule_details_t
13178: WHERE error_value = -1400
13179: HAVING count(*) > 0
13180: UNION
13181: SELECT ''ALL'' column_name,

Line 13184: FROM xla_rule_details_t

13180: UNION
13181: SELECT ''ALL'' column_name,
13182: ''Invalid Value Error'' parameters,
13183: count(*) records
13184: FROM xla_rule_details_t
13185: WHERE error_value = -6502
13186: HAVING count(*) > 0
13187: UNION
13188: SELECT ''ALL'' column_name,

Line 13191: FROM xla_rule_details_t

13187: UNION
13188: SELECT ''ALL'' column_name,
13189: ''Parent-Key Not Found Error'' parameters,
13190: count(*) records
13191: FROM xla_rule_details_t
13192: WHERE error_value = -2291
13193: HAVING count(*) > 0
13194: UNION
13195: SELECT ''ALL'' column_name,

Line 13198: FROM xla_rule_details_t

13194: UNION
13195: SELECT ''ALL'' column_name,
13196: ''Value Too Long Error'' parameters,
13197: count(*) records
13198: FROM xla_rule_details_t
13199: WHERE error_value in (-1438, -12899)
13200: HAVING count(*) > 0
13201: UNION
13202: SELECT ''ALL'' column_name,

Line 13205: FROM xla_rule_details_t

13201: UNION
13202: SELECT ''ALL'' column_name,
13203: ''Invalid Number Error'' parameters,
13204: count(*) records
13205: FROM xla_rule_details_t
13206: WHERE error_value = -1722
13207: HAVING count(*) > 0
13208: UNION
13209: SELECT ''ALL'' column_name,

Line 13212: FROM xla_rule_details_t

13208: UNION
13209: SELECT ''ALL'' column_name,
13210: ''Records not Picked up'' parameters,
13211: count(*) records
13212: FROM xla_rule_details_t
13213: WHERE error_value = 0
13214: HAVING count(*) > 0
13215: UNION
13216: SELECT ''ALL'' column_name,

Line 13219: FROM xla_rule_details_t

13215: UNION
13216: SELECT ''ALL'' column_name,
13217: ''Other Errors'' parameters,
13218: count(*) records
13219: FROM xla_rule_details_t
13220: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13221: HAVING count(*) > 0
13222: ) xla_rule_details_t';
13223: l_xla_conditions_t VARCHAR2(32000) := 'SELECT ''XLA_CONDITIONS_T'' table_name,

Line 13222: ) xla_rule_details_t';

13218: count(*) records
13219: FROM xla_rule_details_t
13220: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13221: HAVING count(*) > 0
13222: ) xla_rule_details_t';
13223: l_xla_conditions_t VARCHAR2(32000) := 'SELECT ''XLA_CONDITIONS_T'' table_name,
13224: xla_conditions_t.*
13225: FROM (
13226: SELECT ''ALL'' column_name,

Line 13615: * Migration Error Logging for table XLA_RULE_DETAILS_T *

13611: FROM xla_rules_t;
13612: END IF;
13613: END IF;
13614: /*******************************************************
13615: * Migration Error Logging for table XLA_RULE_DETAILS_T *
13616: *******************************************************/
13617: IF l_table_name IN ('XLA_RULE_DETAILS_T') THEN
13618: IF p_log_level = 1 THEN
13619: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

Line 13617: IF l_table_name IN ('XLA_RULE_DETAILS_T') THEN

13613: END IF;
13614: /*******************************************************
13615: * Migration Error Logging for table XLA_RULE_DETAILS_T *
13616: *******************************************************/
13617: IF l_table_name IN ('XLA_RULE_DETAILS_T') THEN
13618: IF p_log_level = 1 THEN
13619: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13620: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13621: ELSIF p_log_level = 2 THEN

Line 13638: FROM xla_rule_details_t;

13634: l_too_long_error_count,
13635: l_invalid_number_error_count,
13636: l_not_picked_up_error_count,
13637: l_total_error_count
13638: FROM xla_rule_details_t;
13639: END IF;
13640: END IF;
13641: /*******************************************************
13642: * Migration Error Logging for table XLA_CONDITIONS_T *

Line 14006: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN

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;
14008: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14009: CLOSE cur_gmf_log_errors;
14010: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN

Line 14007: OPEN cur_gmf_log_errors FOR l_xla_rule_details_t;

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;
14008: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14009: CLOSE cur_gmf_log_errors;
14010: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN
14011: OPEN cur_gmf_log_errors FOR l_xla_conditions_t;