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 6903: FROM xla_rule_details_t

6899: ELSE
6900: BEGIN
6901: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
6902: INTO l_adr_priority
6903: FROM xla_rule_details_t
6904: WHERE application_id = G_Application_id
6905: AND segment_rule_code = l_adr_rule_code
6906: AND amb_context_code = l_amb_context;
6907: EXCEPTION

Line 6977: * Loading XLA_RULE_DETAILS_T Structure *

6973: i.segment_delimiter c
6974: FROM dual
6975: );
6976: /***************************************
6977: * Loading XLA_RULE_DETAILS_T Structure *
6978: ***************************************/
6979: BEGIN
6980: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
6981: INTO l_adr_priority

Line 6982: FROM xla_rule_details_t

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

Line 6991: INSERT INTO xla_rule_details_t

6987: WHEN no_data_found THEN
6988: l_adr_priority := 10;
6989: END;
6990: l_segment_rule_detail_id := NULL;
6991: INSERT INTO xla_rule_details_t
6992: (
6993: APPLICATION_ID,
6994: AMB_CONTEXT_CODE,
6995: SEGMENT_RULE_TYPE_CODE,

Line 7126: FROM xla_rule_details_t

7122: IF mcnt > 1 THEN
7123: BEGIN
7124: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7125: INTO l_adr_priority
7126: FROM xla_rule_details_t
7127: WHERE application_id = G_Application_id
7128: AND segment_rule_code = l_adr_rule_code
7129: AND amb_context_code = l_amb_context;
7130: EXCEPTION

Line 7135: INSERT INTO xla_rule_details_t

7131: WHEN no_data_found THEN
7132: l_adr_priority := 10;
7133: END;
7134: l_segment_rule_detail_id := NULL;
7135: INSERT INTO xla_rule_details_t
7136: (
7137: APPLICATION_ID,
7138: AMB_CONTEXT_CODE,
7139: SEGMENT_RULE_TYPE_CODE,

Line 7265: FROM xla_rule_details_t

7261: IF NVL(l.inventory_org_ind,'N') = 'Y' AND nvl(mcnt, 1) > 1 THEN
7262: BEGIN
7263: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7264: INTO l_adr_priority
7265: FROM xla_rule_details_t
7266: WHERE application_id = G_Application_id
7267: AND segment_rule_code = l_adr_rule_code
7268: AND amb_context_code = l_amb_context;
7269: EXCEPTION

Line 7274: INSERT INTO xla_rule_details_t

7270: WHEN no_data_found THEN
7271: l_adr_priority := 10;
7272: END;
7273: l_segment_rule_detail_id := NULL;
7274: INSERT INTO xla_rule_details_t
7275: (
7276: APPLICATION_ID,
7277: AMB_CONTEXT_CODE,
7278: SEGMENT_RULE_TYPE_CODE,

Line 7461: FROM xla_rule_details_t

7457: ELSE
7458: BEGIN
7459: SELECT nvl(MAX(nvl(user_sequence,0)) + 10,10)
7460: INTO l_adr_priority
7461: FROM xla_rule_details_t
7462: WHERE application_id = G_Application_id
7463: AND segment_rule_code = l_adr_rule_code
7464: AND amb_context_code = l_amb_context;
7465: EXCEPTION

Line 7765: * Loading XLA_RULE_DETAILS_T Structure *

7761: i.segment_delimiter c
7762: FROM dual
7763: );
7764: /***************************************
7765: * Loading XLA_RULE_DETAILS_T Structure *
7766: ***************************************/
7767: BEGIN
7768: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
7769: INTO l_adr_priority

Line 7770: FROM xla_rule_details_t

7766: ***************************************/
7767: BEGIN
7768: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
7769: INTO l_adr_priority
7770: FROM xla_rule_details_t
7771: WHERE application_id = G_Application_id
7772: AND segment_rule_code = l_adr_rule_code
7773: AND amb_context_code = l_amb_context;
7774: EXCEPTION

Line 7779: INSERT INTO xla_rule_details_t

7775: WHEN no_data_found THEN
7776: l_adr_priority := 10;
7777: END;
7778: l_segment_rule_detail_id := NULL;
7779: INSERT INTO xla_rule_details_t
7780: (
7781: APPLICATION_ID,
7782: AMB_CONTEXT_CODE,
7783: SEGMENT_RULE_TYPE_CODE,

Line 8138: FROM xla_rule_details_t

8134: IF mcnt > 1 THEN
8135: BEGIN
8136: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
8137: INTO l_adr_priority
8138: FROM xla_rule_details_t
8139: WHERE application_id = G_Application_id
8140: AND segment_rule_code = l_adr_rule_code
8141: AND amb_context_code = l_amb_context;
8142: EXCEPTION

Line 8146: INSERT INTO xla_rule_details_t

8142: EXCEPTION
8143: WHEN no_data_found THEN
8144: l_adr_priority := 10;
8145: END;
8146: INSERT INTO xla_rule_details_t
8147: (
8148: APPLICATION_ID,
8149: AMB_CONTEXT_CODE,
8150: SEGMENT_RULE_TYPE_CODE,

Line 8295: FROM xla_rule_details_t

8291: IF NVL(l_inventory_org_ind(m),'N') = 'Y' AND nvl(mcnt, 1) > 1 THEN
8292: BEGIN
8293: SELECT NVL(MAX(nvl(user_sequence,0)) + 10,10)
8294: INTO l_adr_priority
8295: FROM xla_rule_details_t
8296: WHERE application_id = G_Application_id
8297: AND segment_rule_code = l_adr_rule_code
8298: AND amb_context_code = l_amb_context;
8299: EXCEPTION

Line 8304: INSERT INTO xla_rule_details_t

8300: WHEN no_data_found THEN
8301: l_adr_priority := 10;
8302: END;
8303: l_segment_rule_detail_id := NULL;
8304: INSERT INTO xla_rule_details_t
8305: (
8306: APPLICATION_ID,
8307: AMB_CONTEXT_CODE,
8308: SEGMENT_RULE_TYPE_CODE,

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

8494: );
8495: /*******************************************
8496: * ADR Rule Details Migration Error Logging *
8497: *******************************************/
8498: gmf_migration.G_Table_name := 'XLA_RULE_DETAILS_T';
8499: gmf_migration.G_context := 'GMF Error Logging';
8500: gmf_migration.Log_Errors (
8501: p_log_level => 1,
8502: p_from_rowid => NULL,

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

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

Line 12834: xla_rule_details_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,
12837: ''Unique Constraint Error'' parameters,
12838: count(*) records

Line 12839: FROM xla_rule_details_t

12835: FROM (
12836: SELECT ''ALL'' column_name,
12837: ''Unique Constraint Error'' parameters,
12838: count(*) records
12839: FROM xla_rule_details_t
12840: WHERE error_value = -1
12841: HAVING count(*) > 0
12842: UNION
12843: SELECT ''ALL'' column_name,

Line 12846: FROM xla_rule_details_t

12842: UNION
12843: SELECT ''ALL'' column_name,
12844: ''Not Null Constraint'' parameters,
12845: count(*) records
12846: FROM xla_rule_details_t
12847: WHERE error_value = -1400
12848: HAVING count(*) > 0
12849: UNION
12850: SELECT ''ALL'' column_name,

Line 12853: FROM xla_rule_details_t

12849: UNION
12850: SELECT ''ALL'' column_name,
12851: ''Invalid Value Error'' parameters,
12852: count(*) records
12853: FROM xla_rule_details_t
12854: WHERE error_value = -6502
12855: HAVING count(*) > 0
12856: UNION
12857: SELECT ''ALL'' column_name,

Line 12860: FROM xla_rule_details_t

12856: UNION
12857: SELECT ''ALL'' column_name,
12858: ''Parent-Key Not Found Error'' parameters,
12859: count(*) records
12860: FROM xla_rule_details_t
12861: WHERE error_value = -2291
12862: HAVING count(*) > 0
12863: UNION
12864: SELECT ''ALL'' column_name,

Line 12867: FROM xla_rule_details_t

12863: UNION
12864: SELECT ''ALL'' column_name,
12865: ''Value Too Long Error'' parameters,
12866: count(*) records
12867: FROM xla_rule_details_t
12868: WHERE error_value in (-1438, -12899)
12869: HAVING count(*) > 0
12870: UNION
12871: SELECT ''ALL'' column_name,

Line 12874: FROM xla_rule_details_t

12870: UNION
12871: SELECT ''ALL'' column_name,
12872: ''Invalid Number Error'' parameters,
12873: count(*) records
12874: FROM xla_rule_details_t
12875: WHERE error_value = -1722
12876: HAVING count(*) > 0
12877: UNION
12878: SELECT ''ALL'' column_name,

Line 12881: FROM xla_rule_details_t

12877: UNION
12878: SELECT ''ALL'' column_name,
12879: ''Records not Picked up'' parameters,
12880: count(*) records
12881: FROM xla_rule_details_t
12882: WHERE error_value = 0
12883: HAVING count(*) > 0
12884: UNION
12885: SELECT ''ALL'' column_name,

Line 12888: FROM xla_rule_details_t

12884: UNION
12885: SELECT ''ALL'' column_name,
12886: ''Other Errors'' parameters,
12887: count(*) records
12888: FROM xla_rule_details_t
12889: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12890: HAVING count(*) > 0
12891: ) xla_rule_details_t';
12892: l_xla_conditions_t VARCHAR2(32000) := 'SELECT ''XLA_CONDITIONS_T'' table_name,

Line 12891: ) xla_rule_details_t';

12887: count(*) records
12888: FROM xla_rule_details_t
12889: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12890: HAVING count(*) > 0
12891: ) xla_rule_details_t';
12892: l_xla_conditions_t VARCHAR2(32000) := 'SELECT ''XLA_CONDITIONS_T'' table_name,
12893: xla_conditions_t.*
12894: FROM (
12895: SELECT ''ALL'' column_name,

Line 13284: * Migration Error Logging for table XLA_RULE_DETAILS_T *

13280: FROM xla_rules_t;
13281: END IF;
13282: END IF;
13283: /*******************************************************
13284: * Migration Error Logging for table XLA_RULE_DETAILS_T *
13285: *******************************************************/
13286: IF l_table_name IN ('XLA_RULE_DETAILS_T') THEN
13287: IF p_log_level = 1 THEN
13288: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

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

13282: END IF;
13283: /*******************************************************
13284: * Migration Error Logging for table XLA_RULE_DETAILS_T *
13285: *******************************************************/
13286: IF l_table_name IN ('XLA_RULE_DETAILS_T') THEN
13287: IF p_log_level = 1 THEN
13288: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13289: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13290: ELSIF p_log_level = 2 THEN

Line 13307: FROM xla_rule_details_t;

13303: l_too_long_error_count,
13304: l_invalid_number_error_count,
13305: l_not_picked_up_error_count,
13306: l_total_error_count
13307: FROM xla_rule_details_t;
13308: END IF;
13309: END IF;
13310: /*******************************************************
13311: * Migration Error Logging for table XLA_CONDITIONS_T *

Line 13675: ELSIF l_table_name = 'XLA_RULE_DETAILS_T' THEN

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;
13677: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13678: CLOSE cur_gmf_log_errors;
13679: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN

Line 13676: OPEN cur_gmf_log_errors FOR l_xla_rule_details_t;

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;
13677: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13678: CLOSE cur_gmf_log_errors;
13679: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN
13680: OPEN cur_gmf_log_errors FOR l_xla_conditions_t;