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_CONDITIONS_T

Line 6837: * Loading XLA_CONDITIONS_T Structure *

6833: l_logical_operator_code := p_logical_operator;
6834: END IF;
6835: END IF;
6836: /***************************************
6837: * Loading XLA_CONDITIONS_T Structure *
6838: ***************************************/
6839: INSERT INTO xla_conditions_t
6840: (
6841: CONDITION_ID,

Line 6839: INSERT INTO xla_conditions_t

6835: END IF;
6836: /***************************************
6837: * Loading XLA_CONDITIONS_T Structure *
6838: ***************************************/
6839: INSERT INTO xla_conditions_t
6840: (
6841: CONDITION_ID,
6842: APPLICATION_ID,
6843: AMB_CONTEXT_CODE,

Line 7453: UPDATE xla_conditions_t

7449: );
7450: END IF;
7451: ELSIF NVL(l.inventory_org_ind,'N') <> 'Y' THEN
7452: BEGIN
7453: UPDATE xla_conditions_t
7454: SET logical_operator_code = NULL
7455: WHERE user_sequence = l_adr_condition_priority
7456: AND segment_rule_detail_id = l_segment_rule_detail_id
7457: AND amb_context_code = l_amb_context;

Line 7477: UPDATE xla_conditions_t

7473: END IF;
7474: END IF;
7475: ELSE
7476: BEGIN
7477: UPDATE xla_conditions_t
7478: SET logical_operator_code = NULL
7479: WHERE user_sequence = l_adr_condition_priority
7480: AND segment_rule_detail_id = l_segment_rule_detail_id
7481: AND amb_context_code = l_amb_context;

Line 8283: INSERT INTO xla_conditions_t

8279: NULL,
8280: NULL,
8281: 0
8282: ) returning segment_rule_detail_id INTO l_segment_rule_detail_id;
8283: INSERT INTO xla_conditions_t
8284: (
8285: CONDITION_ID,
8286: APPLICATION_ID,
8287: AMB_CONTEXT_CODE,

Line 8329: FROM xla_conditions_t

8325: LINE_OPERATOR_CODE,
8326: LOGICAL_OPERATOR_CODE,
8327: INDEPENDENT_VALUE_CONSTANT,
8328: ERROR_VALUE
8329: FROM xla_conditions_t
8330: WHERE segment_rule_detail_id = l_old_segment_rule_detail_id
8331: AND amb_context_code = l_amb_context
8332: AND user_sequence <= l_old_adr_condition_priority
8333: );

Line 8441: INSERT INTO xla_conditions_t

8437: NULL,
8438: NULL,
8439: 0
8440: ) returning segment_rule_detail_id INTO l_segment_rule_detail_id;
8441: INSERT INTO xla_conditions_t
8442: (
8443: CONDITION_ID,
8444: APPLICATION_ID,
8445: AMB_CONTEXT_CODE,

Line 8487: FROM xla_conditions_t

8483: LINE_OPERATOR_CODE,
8484: LOGICAL_OPERATOR_CODE,
8485: INDEPENDENT_VALUE_CONSTANT,
8486: ERROR_VALUE
8487: FROM xla_conditions_t
8488: WHERE segment_rule_detail_id = l_old_segment_rule_detail_id
8489: AND amb_context_code = l_amb_context
8490: AND user_sequence <= l_old_adr_condition_priority
8491: );

Line 8505: UPDATE xla_conditions_t

8501: p_segment_rule_detail_id => l_segment_rule_detail_id
8502: );
8503: ELSIF NVL(l_inventory_org_ind(m),'N') <> 'Y' THEN
8504: BEGIN
8505: UPDATE xla_conditions_t
8506: SET logical_operator_code = NULL
8507: WHERE user_sequence = l_adr_condition_priority
8508: AND segment_rule_detail_id = l_segment_rule_detail_id
8509: AND amb_context_code = l_amb_context;

Line 8529: UPDATE xla_conditions_t

8525: END IF;
8526: END IF;
8527: ELSE
8528: BEGIN
8529: UPDATE xla_conditions_t
8530: SET logical_operator_code = NULL
8531: WHERE user_sequence = l_adr_condition_priority
8532: AND segment_rule_detail_id = l_segment_rule_detail_id
8533: AND amb_context_code = l_amb_context;

Line 8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';

8592: );
8593: /*****************************************
8594: * ADR Conditions Migration Error Logging *
8595: *****************************************/
8596: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8597: gmf_migration.G_context := 'GMF Error Logging';
8598: gmf_migration.Log_Errors (
8599: p_log_level => 1,
8600: p_from_rowid => NULL,

Line 13223: l_xla_conditions_t VARCHAR2(32000) := 'SELECT ''XLA_CONDITIONS_T'' table_name,

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

Line 13224: xla_conditions_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,
13227: ''Unique Constraint Error'' parameters,
13228: count(*) records

Line 13229: FROM xla_conditions_t

13225: FROM (
13226: SELECT ''ALL'' column_name,
13227: ''Unique Constraint Error'' parameters,
13228: count(*) records
13229: FROM xla_conditions_t
13230: WHERE error_value = -1
13231: HAVING count(*) > 0
13232: UNION
13233: SELECT ''ALL'' column_name,

Line 13236: FROM xla_conditions_t

13232: UNION
13233: SELECT ''ALL'' column_name,
13234: ''Not Null Constraint'' parameters,
13235: count(*) records
13236: FROM xla_conditions_t
13237: WHERE error_value = -1400
13238: HAVING count(*) > 0
13239: UNION
13240: SELECT ''ALL'' column_name,

Line 13243: FROM xla_conditions_t

13239: UNION
13240: SELECT ''ALL'' column_name,
13241: ''Invalid Value Error'' parameters,
13242: count(*) records
13243: FROM xla_conditions_t
13244: WHERE error_value = -6502
13245: HAVING count(*) > 0
13246: UNION
13247: SELECT ''ALL'' column_name,

Line 13250: FROM xla_conditions_t

13246: UNION
13247: SELECT ''ALL'' column_name,
13248: ''Parent-Key Not Found Error'' parameters,
13249: count(*) records
13250: FROM xla_conditions_t
13251: WHERE error_value = -2291
13252: HAVING count(*) > 0
13253: UNION
13254: SELECT ''ALL'' column_name,

Line 13257: FROM xla_conditions_t

13253: UNION
13254: SELECT ''ALL'' column_name,
13255: ''Value Too Long Error'' parameters,
13256: count(*) records
13257: FROM xla_conditions_t
13258: WHERE error_value in (-1438, -12899)
13259: HAVING count(*) > 0
13260: UNION
13261: SELECT ''ALL'' column_name,

Line 13264: FROM xla_conditions_t

13260: UNION
13261: SELECT ''ALL'' column_name,
13262: ''Invalid Number Error'' parameters,
13263: count(*) records
13264: FROM xla_conditions_t
13265: WHERE error_value = -1722
13266: HAVING count(*) > 0
13267: UNION
13268: SELECT ''ALL'' column_name,

Line 13271: FROM xla_conditions_t

13267: UNION
13268: SELECT ''ALL'' column_name,
13269: ''Records not Picked up'' parameters,
13270: count(*) records
13271: FROM xla_conditions_t
13272: WHERE error_value = 0
13273: HAVING count(*) > 0
13274: UNION
13275: SELECT ''ALL'' column_name,

Line 13278: FROM xla_conditions_t

13274: UNION
13275: SELECT ''ALL'' column_name,
13276: ''Other Errors'' parameters,
13277: count(*) records
13278: FROM xla_conditions_t
13279: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13280: HAVING count(*) > 0
13281: ) xla_conditions_t';
13282: l_xla_line_assgns_t VARCHAR2(32000) := 'SELECT ''XLA_LINE_ASSGNS_T'' table_name,

Line 13281: ) xla_conditions_t';

13277: count(*) records
13278: FROM xla_conditions_t
13279: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13280: HAVING count(*) > 0
13281: ) xla_conditions_t';
13282: l_xla_line_assgns_t VARCHAR2(32000) := 'SELECT ''XLA_LINE_ASSGNS_T'' table_name,
13283: xla_line_assgns_t.*
13284: FROM (
13285: SELECT ''ALL'' column_name,

Line 13642: * Migration Error Logging for table XLA_CONDITIONS_T *

13638: FROM xla_rule_details_t;
13639: END IF;
13640: END IF;
13641: /*******************************************************
13642: * Migration Error Logging for table XLA_CONDITIONS_T *
13643: *******************************************************/
13644: IF l_table_name IN ('XLA_CONDITIONS_T') THEN
13645: IF p_log_level = 1 THEN
13646: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

Line 13644: IF l_table_name IN ('XLA_CONDITIONS_T') THEN

13640: END IF;
13641: /*******************************************************
13642: * Migration Error Logging for table XLA_CONDITIONS_T *
13643: *******************************************************/
13644: IF l_table_name IN ('XLA_CONDITIONS_T') THEN
13645: IF p_log_level = 1 THEN
13646: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13647: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13648: ELSIF p_log_level = 2 THEN

Line 13665: FROM xla_conditions_t;

13661: l_too_long_error_count,
13662: l_invalid_number_error_count,
13663: l_not_picked_up_error_count,
13664: l_total_error_count
13665: FROM xla_conditions_t;
13666: END IF;
13667: END IF;
13668: /*******************************************************
13669: * Migration Error Logging for table XLA_LINE_ASSGNS_T *

Line 14010: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN

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;
14012: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14013: CLOSE cur_gmf_log_errors;
14014: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN

Line 14011: OPEN cur_gmf_log_errors FOR l_xla_conditions_t;

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;
14012: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14013: CLOSE cur_gmf_log_errors;
14014: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN
14015: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;