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_LINE_ASSGNS_T

Line 6996: * Loading XLA_LINE_ASSGNS_T Structure *

6992: END IF;
6993: <>
6994: FOR m IN cur_sub_event_code (k.acct_ttl_type) LOOP
6995: /***************************************
6996: * Loading XLA_LINE_ASSGNS_T Structure *
6997: ***************************************/
6998: BEGIN
6999: SELECT count(*)
7000: INTO xlat

Line 7001: FROM xla_line_assgns_t

6997: ***************************************/
6998: BEGIN
6999: SELECT count(*)
7000: INTO xlat
7001: FROM xla_line_assgns_t
7002: WHERE application_id = G_Application_id
7003: AND amb_context_code = l_amb_context
7004: AND event_class_code = m.event_class_code
7005: AND event_type_code = m.event_type_code

Line 7015: INSERT INTO xla_line_assgns_t

7011: WHEN no_data_found THEN
7012: xlat := 0;
7013: END;
7014: IF nvl(xlat,0) = 0 THEN
7015: INSERT INTO xla_line_assgns_t
7016: (
7017: APPLICATION_ID,
7018: AMB_CONTEXT_CODE,
7019: EVENT_CLASS_CODE,

Line 7558: * Loading XLA_LINE_ASSGNS_T Structure *

7554: END IF;
7555: <>
7556: FOR m IN cur_sub_event_code (k.acct_ttl_type) LOOP
7557: /***************************************
7558: * Loading XLA_LINE_ASSGNS_T Structure *
7559: ***************************************/
7560: BEGIN
7561: SELECT count(*)
7562: INTO xlat

Line 7563: FROM xla_line_assgns_t

7559: ***************************************/
7560: BEGIN
7561: SELECT count(*)
7562: INTO xlat
7563: FROM xla_line_assgns_t
7564: WHERE application_id = G_Application_id
7565: AND amb_context_code = l_amb_context
7566: AND event_class_code = m.event_class_code
7567: AND event_type_code = m.event_type_code

Line 7577: INSERT INTO xla_line_assgns_t

7573: WHEN no_data_found THEN
7574: xlat := 0;
7575: END;
7576: IF nvl(xlat,0) = 0 THEN
7577: INSERT INTO xla_line_assgns_t
7578: (
7579: APPLICATION_ID,
7580: AMB_CONTEXT_CODE,
7581: EVENT_CLASS_CODE,

Line 8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';

8602: );
8603: /***********************************************
8604: * ADR Line Assignments Migration Error Logging *
8605: ***********************************************/
8606: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8607: gmf_migration.G_context := 'GMF Error Logging';
8608: gmf_migration.Log_Errors (
8609: p_log_level => 1,
8610: p_from_rowid => NULL,

Line 13282: l_xla_line_assgns_t VARCHAR2(32000) := 'SELECT ''XLA_LINE_ASSGNS_T'' table_name,

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

Line 13283: xla_line_assgns_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,
13286: ''Unique Constraint Error'' parameters,
13287: count(*) records

Line 13288: FROM xla_line_assgns_t

13284: FROM (
13285: SELECT ''ALL'' column_name,
13286: ''Unique Constraint Error'' parameters,
13287: count(*) records
13288: FROM xla_line_assgns_t
13289: WHERE error_value = -1
13290: HAVING count(*) > 0
13291: UNION
13292: SELECT ''ALL'' column_name,

Line 13295: FROM xla_line_assgns_t

13291: UNION
13292: SELECT ''ALL'' column_name,
13293: ''Not Null Constraint'' parameters,
13294: count(*) records
13295: FROM xla_line_assgns_t
13296: WHERE error_value = -1400
13297: HAVING count(*) > 0
13298: UNION
13299: SELECT ''ALL'' column_name,

Line 13302: FROM xla_line_assgns_t

13298: UNION
13299: SELECT ''ALL'' column_name,
13300: ''Invalid Value Error'' parameters,
13301: count(*) records
13302: FROM xla_line_assgns_t
13303: WHERE error_value = -6502
13304: HAVING count(*) > 0
13305: UNION
13306: SELECT ''ALL'' column_name,

Line 13309: FROM xla_line_assgns_t

13305: UNION
13306: SELECT ''ALL'' column_name,
13307: ''Parent-Key Not Found Error'' parameters,
13308: count(*) records
13309: FROM xla_line_assgns_t
13310: WHERE error_value = -2291
13311: HAVING count(*) > 0
13312: UNION
13313: SELECT ''ALL'' column_name,

Line 13316: FROM xla_line_assgns_t

13312: UNION
13313: SELECT ''ALL'' column_name,
13314: ''Value Too Long Error'' parameters,
13315: count(*) records
13316: FROM xla_line_assgns_t
13317: WHERE error_value in (-1438, -12899)
13318: HAVING count(*) > 0
13319: UNION
13320: SELECT ''ALL'' column_name,

Line 13323: FROM xla_line_assgns_t

13319: UNION
13320: SELECT ''ALL'' column_name,
13321: ''Invalid Number Error'' parameters,
13322: count(*) records
13323: FROM xla_line_assgns_t
13324: WHERE error_value = -1722
13325: HAVING count(*) > 0
13326: UNION
13327: SELECT ''ALL'' column_name,

Line 13330: FROM xla_line_assgns_t

13326: UNION
13327: SELECT ''ALL'' column_name,
13328: ''Records not Picked up'' parameters,
13329: count(*) records
13330: FROM xla_line_assgns_t
13331: WHERE error_value = 0
13332: HAVING count(*) > 0
13333: UNION
13334: SELECT ''ALL'' column_name,

Line 13337: FROM xla_line_assgns_t

13333: UNION
13334: SELECT ''ALL'' column_name,
13335: ''Other Errors'' parameters,
13336: count(*) records
13337: FROM xla_line_assgns_t
13338: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13339: HAVING count(*) > 0
13340: ) xla_line_assgns_t';
13341:

Line 13340: ) xla_line_assgns_t';

13336: count(*) records
13337: FROM xla_line_assgns_t
13338: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13339: HAVING count(*) > 0
13340: ) xla_line_assgns_t';
13341:
13342: /*****************
13343: * PL/SQL Cursors *
13344: *****************/

Line 13669: * Migration Error Logging for table XLA_LINE_ASSGNS_T *

13665: FROM xla_conditions_t;
13666: END IF;
13667: END IF;
13668: /*******************************************************
13669: * Migration Error Logging for table XLA_LINE_ASSGNS_T *
13670: *******************************************************/
13671: IF l_table_name IN ('XLA_LINE_ASSGNS_T') THEN
13672: IF p_log_level = 1 THEN
13673: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

Line 13671: IF l_table_name IN ('XLA_LINE_ASSGNS_T') THEN

13667: END IF;
13668: /*******************************************************
13669: * Migration Error Logging for table XLA_LINE_ASSGNS_T *
13670: *******************************************************/
13671: IF l_table_name IN ('XLA_LINE_ASSGNS_T') THEN
13672: IF p_log_level = 1 THEN
13673: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13674: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13675: ELSIF p_log_level = 2 THEN

Line 13692: FROM xla_line_assgns_t;

13688: l_too_long_error_count,
13689: l_invalid_number_error_count,
13690: l_not_picked_up_error_count,
13691: l_total_error_count
13692: FROM xla_line_assgns_t;
13693: END IF;
13694: END IF;
13695: /**************************************************
13696: * Migration Error Logging for table GMF_LOT_COSTS *

Line 14014: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN

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;
14016: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14017: CLOSE cur_gmf_log_errors;
14018: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN

Line 14015: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;

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;
14016: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14017: CLOSE cur_gmf_log_errors;
14018: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN
14019: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;