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 6915: * Loading XLA_LINE_ASSGNS_T Structure *

6911: END IF;
6912: <>
6913: FOR m IN cur_sub_event_code (k.acct_ttl_type) LOOP
6914: /***************************************
6915: * Loading XLA_LINE_ASSGNS_T Structure *
6916: ***************************************/
6917: BEGIN
6918: SELECT count(*)
6919: INTO xlat

Line 6920: FROM xla_line_assgns_t

6916: ***************************************/
6917: BEGIN
6918: SELECT count(*)
6919: INTO xlat
6920: FROM xla_line_assgns_t
6921: WHERE application_id = G_Application_id
6922: AND amb_context_code = l_amb_context
6923: AND event_class_code = m.event_class_code
6924: AND event_type_code = m.event_type_code

Line 6934: INSERT INTO xla_line_assgns_t

6930: WHEN no_data_found THEN
6931: xlat := 0;
6932: END;
6933: IF nvl(xlat,0) = 0 THEN
6934: INSERT INTO xla_line_assgns_t
6935: (
6936: APPLICATION_ID,
6937: AMB_CONTEXT_CODE,
6938: EVENT_CLASS_CODE,

Line 7473: * Loading XLA_LINE_ASSGNS_T Structure *

7469: END IF;
7470: <>
7471: FOR m IN cur_sub_event_code (k.acct_ttl_type) LOOP
7472: /***************************************
7473: * Loading XLA_LINE_ASSGNS_T Structure *
7474: ***************************************/
7475: BEGIN
7476: SELECT count(*)
7477: INTO xlat

Line 7478: FROM xla_line_assgns_t

7474: ***************************************/
7475: BEGIN
7476: SELECT count(*)
7477: INTO xlat
7478: FROM xla_line_assgns_t
7479: WHERE application_id = G_Application_id
7480: AND amb_context_code = l_amb_context
7481: AND event_class_code = m.event_class_code
7482: AND event_type_code = m.event_type_code

Line 7492: INSERT INTO xla_line_assgns_t

7488: WHEN no_data_found THEN
7489: xlat := 0;
7490: END;
7491: IF nvl(xlat,0) = 0 THEN
7492: INSERT INTO xla_line_assgns_t
7493: (
7494: APPLICATION_ID,
7495: AMB_CONTEXT_CODE,
7496: EVENT_CLASS_CODE,

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

8514: );
8515: /***********************************************
8516: * ADR Line Assignments Migration Error Logging *
8517: ***********************************************/
8518: gmf_migration.G_Table_name := 'XLA_LINE_ASSGNS_T';
8519: gmf_migration.G_context := 'GMF Error Logging';
8520: gmf_migration.Log_Errors (
8521: p_log_level => 1,
8522: p_from_rowid => NULL,

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

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

Line 12952: xla_line_assgns_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,
12955: ''Unique Constraint Error'' parameters,
12956: count(*) records

Line 12957: FROM xla_line_assgns_t

12953: FROM (
12954: SELECT ''ALL'' column_name,
12955: ''Unique Constraint Error'' parameters,
12956: count(*) records
12957: FROM xla_line_assgns_t
12958: WHERE error_value = -1
12959: HAVING count(*) > 0
12960: UNION
12961: SELECT ''ALL'' column_name,

Line 12964: FROM xla_line_assgns_t

12960: UNION
12961: SELECT ''ALL'' column_name,
12962: ''Not Null Constraint'' parameters,
12963: count(*) records
12964: FROM xla_line_assgns_t
12965: WHERE error_value = -1400
12966: HAVING count(*) > 0
12967: UNION
12968: SELECT ''ALL'' column_name,

Line 12971: FROM xla_line_assgns_t

12967: UNION
12968: SELECT ''ALL'' column_name,
12969: ''Invalid Value Error'' parameters,
12970: count(*) records
12971: FROM xla_line_assgns_t
12972: WHERE error_value = -6502
12973: HAVING count(*) > 0
12974: UNION
12975: SELECT ''ALL'' column_name,

Line 12978: FROM xla_line_assgns_t

12974: UNION
12975: SELECT ''ALL'' column_name,
12976: ''Parent-Key Not Found Error'' parameters,
12977: count(*) records
12978: FROM xla_line_assgns_t
12979: WHERE error_value = -2291
12980: HAVING count(*) > 0
12981: UNION
12982: SELECT ''ALL'' column_name,

Line 12985: FROM xla_line_assgns_t

12981: UNION
12982: SELECT ''ALL'' column_name,
12983: ''Value Too Long Error'' parameters,
12984: count(*) records
12985: FROM xla_line_assgns_t
12986: WHERE error_value in (-1438, -12899)
12987: HAVING count(*) > 0
12988: UNION
12989: SELECT ''ALL'' column_name,

Line 12992: FROM xla_line_assgns_t

12988: UNION
12989: SELECT ''ALL'' column_name,
12990: ''Invalid Number Error'' parameters,
12991: count(*) records
12992: FROM xla_line_assgns_t
12993: WHERE error_value = -1722
12994: HAVING count(*) > 0
12995: UNION
12996: SELECT ''ALL'' column_name,

Line 12999: FROM xla_line_assgns_t

12995: UNION
12996: SELECT ''ALL'' column_name,
12997: ''Records not Picked up'' parameters,
12998: count(*) records
12999: FROM xla_line_assgns_t
13000: WHERE error_value = 0
13001: HAVING count(*) > 0
13002: UNION
13003: SELECT ''ALL'' column_name,

Line 13006: FROM xla_line_assgns_t

13002: UNION
13003: SELECT ''ALL'' column_name,
13004: ''Other Errors'' parameters,
13005: count(*) records
13006: FROM xla_line_assgns_t
13007: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13008: HAVING count(*) > 0
13009: ) xla_line_assgns_t';
13010:

Line 13009: ) xla_line_assgns_t';

13005: count(*) records
13006: FROM xla_line_assgns_t
13007: WHERE error_value not in (-1, -1400, -6502, -2291, -1438, -12899, -1722, 1, 0)
13008: HAVING count(*) > 0
13009: ) xla_line_assgns_t';
13010:
13011: /*****************
13012: * PL/SQL Cursors *
13013: *****************/

Line 13338: * Migration Error Logging for table XLA_LINE_ASSGNS_T *

13334: FROM xla_conditions_t;
13335: END IF;
13336: END IF;
13337: /*******************************************************
13338: * Migration Error Logging for table XLA_LINE_ASSGNS_T *
13339: *******************************************************/
13340: IF l_table_name IN ('XLA_LINE_ASSGNS_T') THEN
13341: IF p_log_level = 1 THEN
13342: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';

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

13336: END IF;
13337: /*******************************************************
13338: * Migration Error Logging for table XLA_LINE_ASSGNS_T *
13339: *******************************************************/
13340: IF l_table_name IN ('XLA_LINE_ASSGNS_T') THEN
13341: IF p_log_level = 1 THEN
13342: l_sql_statement := l_sql_statement || ' ERROR_VALUE <> 1 ';
13343: execute IMMEDIATE l_sql_statement INTO l_failure_count;
13344: ELSIF p_log_level = 2 THEN

Line 13361: FROM xla_line_assgns_t;

13357: l_too_long_error_count,
13358: l_invalid_number_error_count,
13359: l_not_picked_up_error_count,
13360: l_total_error_count
13361: FROM xla_line_assgns_t;
13362: END IF;
13363: END IF;
13364: /**************************************************
13365: * Migration Error Logging for table GMF_LOT_COSTS *

Line 13683: ELSIF l_table_name = 'XLA_LINE_ASSGNS_T' THEN

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;
13685: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13686: CLOSE cur_gmf_log_errors;
13687: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN

Line 13684: OPEN cur_gmf_log_errors FOR l_xla_line_assgns_t;

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;
13685: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13686: CLOSE cur_gmf_log_errors;
13687: ELSIF l_table_name = 'GMF_LOT_COSTS' THEN
13688: OPEN cur_gmf_log_errors FOR l_gmf_lot_costs;