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 6756: * Loading XLA_CONDITIONS_T Structure *

6752: l_logical_operator_code := p_logical_operator;
6753: END IF;
6754: END IF;
6755: /***************************************
6756: * Loading XLA_CONDITIONS_T Structure *
6757: ***************************************/
6758: INSERT INTO xla_conditions_t
6759: (
6760: CONDITION_ID,

Line 6758: INSERT INTO xla_conditions_t

6754: END IF;
6755: /***************************************
6756: * Loading XLA_CONDITIONS_T Structure *
6757: ***************************************/
6758: INSERT INTO xla_conditions_t
6759: (
6760: CONDITION_ID,
6761: APPLICATION_ID,
6762: AMB_CONTEXT_CODE,

Line 7368: UPDATE xla_conditions_t

7364: );
7365: END IF;
7366: ELSIF NVL(l.inventory_org_ind,'N') <> 'Y' THEN
7367: BEGIN
7368: UPDATE xla_conditions_t
7369: SET logical_operator_code = NULL
7370: WHERE user_sequence = l_adr_condition_priority
7371: AND segment_rule_detail_id = l_segment_rule_detail_id
7372: AND amb_context_code = l_amb_context;

Line 7392: UPDATE xla_conditions_t

7388: END IF;
7389: END IF;
7390: ELSE
7391: BEGIN
7392: UPDATE xla_conditions_t
7393: SET logical_operator_code = NULL
7394: WHERE user_sequence = l_adr_condition_priority
7395: AND segment_rule_detail_id = l_segment_rule_detail_id
7396: AND amb_context_code = l_amb_context;

Line 8196: INSERT INTO xla_conditions_t

8192: NULL,
8193: NULL,
8194: 0
8195: ) returning segment_rule_detail_id INTO l_segment_rule_detail_id;
8196: INSERT INTO xla_conditions_t
8197: (
8198: CONDITION_ID,
8199: APPLICATION_ID,
8200: AMB_CONTEXT_CODE,

Line 8242: FROM xla_conditions_t

8238: LINE_OPERATOR_CODE,
8239: LOGICAL_OPERATOR_CODE,
8240: INDEPENDENT_VALUE_CONSTANT,
8241: ERROR_VALUE
8242: FROM xla_conditions_t
8243: WHERE segment_rule_detail_id = l_old_segment_rule_detail_id
8244: AND amb_context_code = l_amb_context
8245: AND user_sequence <= l_old_adr_condition_priority
8246: );

Line 8354: INSERT INTO xla_conditions_t

8350: NULL,
8351: NULL,
8352: 0
8353: ) returning segment_rule_detail_id INTO l_segment_rule_detail_id;
8354: INSERT INTO xla_conditions_t
8355: (
8356: CONDITION_ID,
8357: APPLICATION_ID,
8358: AMB_CONTEXT_CODE,

Line 8400: FROM xla_conditions_t

8396: LINE_OPERATOR_CODE,
8397: LOGICAL_OPERATOR_CODE,
8398: INDEPENDENT_VALUE_CONSTANT,
8399: ERROR_VALUE
8400: FROM xla_conditions_t
8401: WHERE segment_rule_detail_id = l_old_segment_rule_detail_id
8402: AND amb_context_code = l_amb_context
8403: AND user_sequence <= l_old_adr_condition_priority
8404: );

Line 8418: UPDATE xla_conditions_t

8414: p_segment_rule_detail_id => l_segment_rule_detail_id
8415: );
8416: ELSIF NVL(l_inventory_org_ind(m),'N') <> 'Y' THEN
8417: BEGIN
8418: UPDATE xla_conditions_t
8419: SET logical_operator_code = NULL
8420: WHERE user_sequence = l_adr_condition_priority
8421: AND segment_rule_detail_id = l_segment_rule_detail_id
8422: AND amb_context_code = l_amb_context;

Line 8442: UPDATE xla_conditions_t

8438: END IF;
8439: END IF;
8440: ELSE
8441: BEGIN
8442: UPDATE xla_conditions_t
8443: SET logical_operator_code = NULL
8444: WHERE user_sequence = l_adr_condition_priority
8445: AND segment_rule_detail_id = l_segment_rule_detail_id
8446: AND amb_context_code = l_amb_context;

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

8504: );
8505: /*****************************************
8506: * ADR Conditions Migration Error Logging *
8507: *****************************************/
8508: gmf_migration.G_Table_name := 'XLA_CONDITIONS_T';
8509: gmf_migration.G_context := 'GMF Error Logging';
8510: gmf_migration.Log_Errors (
8511: p_log_level => 1,
8512: p_from_rowid => NULL,

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

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

Line 12893: xla_conditions_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,
12896: ''Unique Constraint Error'' parameters,
12897: count(*) records

Line 12898: FROM xla_conditions_t

12894: FROM (
12895: SELECT ''ALL'' column_name,
12896: ''Unique Constraint Error'' parameters,
12897: count(*) records
12898: FROM xla_conditions_t
12899: WHERE error_value = -1
12900: HAVING count(*) > 0
12901: UNION
12902: SELECT ''ALL'' column_name,

Line 12905: FROM xla_conditions_t

12901: UNION
12902: SELECT ''ALL'' column_name,
12903: ''Not Null Constraint'' parameters,
12904: count(*) records
12905: FROM xla_conditions_t
12906: WHERE error_value = -1400
12907: HAVING count(*) > 0
12908: UNION
12909: SELECT ''ALL'' column_name,

Line 12912: FROM xla_conditions_t

12908: UNION
12909: SELECT ''ALL'' column_name,
12910: ''Invalid Value Error'' parameters,
12911: count(*) records
12912: FROM xla_conditions_t
12913: WHERE error_value = -6502
12914: HAVING count(*) > 0
12915: UNION
12916: SELECT ''ALL'' column_name,

Line 12919: FROM xla_conditions_t

12915: UNION
12916: SELECT ''ALL'' column_name,
12917: ''Parent-Key Not Found Error'' parameters,
12918: count(*) records
12919: FROM xla_conditions_t
12920: WHERE error_value = -2291
12921: HAVING count(*) > 0
12922: UNION
12923: SELECT ''ALL'' column_name,

Line 12926: FROM xla_conditions_t

12922: UNION
12923: SELECT ''ALL'' column_name,
12924: ''Value Too Long Error'' parameters,
12925: count(*) records
12926: FROM xla_conditions_t
12927: WHERE error_value in (-1438, -12899)
12928: HAVING count(*) > 0
12929: UNION
12930: SELECT ''ALL'' column_name,

Line 12933: FROM xla_conditions_t

12929: UNION
12930: SELECT ''ALL'' column_name,
12931: ''Invalid Number Error'' parameters,
12932: count(*) records
12933: FROM xla_conditions_t
12934: WHERE error_value = -1722
12935: HAVING count(*) > 0
12936: UNION
12937: SELECT ''ALL'' column_name,

Line 12940: FROM xla_conditions_t

12936: UNION
12937: SELECT ''ALL'' column_name,
12938: ''Records not Picked up'' parameters,
12939: count(*) records
12940: FROM xla_conditions_t
12941: WHERE error_value = 0
12942: HAVING count(*) > 0
12943: UNION
12944: SELECT ''ALL'' column_name,

Line 12947: FROM xla_conditions_t

12943: UNION
12944: SELECT ''ALL'' column_name,
12945: ''Other Errors'' parameters,
12946: count(*) records
12947: FROM xla_conditions_t
12948: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12949: HAVING count(*) > 0
12950: ) xla_conditions_t';
12951: l_xla_line_assgns_t VARCHAR2(32000) := 'SELECT ''XLA_LINE_ASSGNS_T'' table_name,

Line 12950: ) xla_conditions_t';

12946: count(*) records
12947: FROM xla_conditions_t
12948: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
12949: HAVING count(*) > 0
12950: ) xla_conditions_t';
12951: l_xla_line_assgns_t VARCHAR2(32000) := 'SELECT ''XLA_LINE_ASSGNS_T'' table_name,
12952: xla_line_assgns_t.*
12953: FROM (
12954: SELECT ''ALL'' column_name,

Line 13311: * Migration Error Logging for table XLA_CONDITIONS_T *

13307: FROM xla_rule_details_t;
13308: END IF;
13309: END IF;
13310: /*******************************************************
13311: * Migration Error Logging for table XLA_CONDITIONS_T *
13312: *******************************************************/
13313: IF l_table_name IN ('XLA_CONDITIONS_T') THEN
13314: IF p_log_level = 1 THEN
13315: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

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

13309: END IF;
13310: /*******************************************************
13311: * Migration Error Logging for table XLA_CONDITIONS_T *
13312: *******************************************************/
13313: IF l_table_name IN ('XLA_CONDITIONS_T') THEN
13314: IF p_log_level = 1 THEN
13315: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13316: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13317: ELSIF p_log_level = 2 THEN

Line 13334: FROM xla_conditions_t;

13330: l_too_long_error_count,
13331: l_invalid_number_error_count,
13332: l_not_picked_up_error_count,
13333: l_total_error_count
13334: FROM xla_conditions_t;
13335: END IF;
13336: END IF;
13337: /*******************************************************
13338: * Migration Error Logging for table XLA_LINE_ASSGNS_T *

Line 13679: ELSIF l_table_name = 'XLA_CONDITIONS_T' THEN

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;
13681: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13682: CLOSE cur_gmf_log_errors;
13683: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN

Line 13680: OPEN cur_gmf_log_errors FOR l_xla_conditions_t;

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;
13681: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13682: CLOSE cur_gmf_log_errors;
13683: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN
13684: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;