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.XLA_AAD_MERGE_PVT dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 718: DELETE FROM xla_line_defn_jlt_assgns w

714: p_log_type_code => 'MERGE',
715: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
716: p_component_code => 'clean_oracle_jlds');
717:
718: DELETE FROM xla_line_defn_jlt_assgns w
719: WHERE application_id = g_application_id
720: AND amb_context_code = g_amb_context_code
721: AND line_definition_owner_code = C_OWNER_SYSTEM
722: AND NOT EXISTS

Line 724: FROM xla_line_defn_jlt_assgns s

720: AND amb_context_code = g_amb_context_code
721: AND line_definition_owner_code = C_OWNER_SYSTEM
722: AND NOT EXISTS
723: (SELECT 1
724: FROM xla_line_defn_jlt_assgns s
725: WHERE s.application_id = g_application_id
726: AND s.amb_context_code = g_staging_context_code
727: AND s.event_class_code = w.event_class_code
728: AND s.event_type_code = w.event_type_code

Line 735: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,

731: AND s.accounting_line_type_code = w.accounting_line_type_code
732: AND s.accounting_line_code = w.accounting_line_code);
733: l_num_rows := SQL%ROWCOUNT;
734: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
735: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
736: p_module => l_log_module,
737: p_level => C_LEVEL_STATEMENT);
738: END IF;
739: -- Bug : 9923803

Line 746: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,

742: p_amb_context_code => g_amb_context_code,
743: p_application_id => g_application_id,
744: p_request_code => 'IMPORT' ,
745: p_log_type_code => 'MERGE',
746: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
747: p_component_code => 'clean_oracle_jlds');
748: DELETE FROM xla_mpa_jlt_assgns w
749: WHERE application_id = g_application_id
750: AND amb_context_code = g_amb_context_code

Line 1130: DELETE FROM xla_line_defn_jlt_assgns w

1126: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
1127: p_component_code => 'clean_oracle_jlts');
1128:
1129: FORALL i IN 1..l_codes.COUNT
1130: DELETE FROM xla_line_defn_jlt_assgns w
1131: WHERE application_id = g_application_id
1132: AND amb_context_code = g_amb_context_code
1133: AND event_class_code = l_event_class_codes(i)
1134: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1138: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,

1134: AND accounting_line_type_code = C_OWNER_SYSTEM
1135: AND accounting_line_code = l_codes(i);
1136: l_num_rows := SQL%ROWCOUNT;
1137: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1138: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
1139: p_module => l_log_module,
1140: p_level => C_LEVEL_STATEMENT);
1141: END IF;
1142: -- Bug : 9923803

Line 1149: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,

1145: p_amb_context_code => g_amb_context_code,
1146: p_application_id => g_application_id,
1147: p_request_code => 'IMPORT' ,
1148: p_log_type_code => 'MERGE',
1149: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
1150: p_component_code => 'clean_oracle_jlts');
1151:
1152: FORALL i IN 1..l_codes.COUNT
1153: DELETE FROM xla_jlt_acct_attrs w

Line 1297: UPDATE xla_line_defn_jlt_assgns

1293: END IF;
1294:
1295: IF (l_codes.COUNT > 0) THEN
1296: FORALL i IN 1..l_codes.COUNT
1297: UPDATE xla_line_defn_jlt_assgns
1298: SET description_type_code = NULL
1299: , description_code = NULL
1300: WHERE application_id = g_application_id
1301: AND amb_context_code = g_amb_context_code

Line 1306: trace(p_msg => '# xla_line_defn_jlt_assgns clear description = '||l_num_rows,

1302: AND description_type_code = C_OWNER_SYSTEM
1303: AND description_code = l_codes(i);
1304: l_num_rows := SQL%ROWCOUNT;
1305: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1306: trace(p_msg => '# xla_line_defn_jlt_assgns clear description = '||l_num_rows,
1307: p_module => l_log_module,
1308: p_level => C_LEVEL_STATEMENT);
1309: END IF;
1310: -- Bug : 9923803

Line 1317: p_encoded_message => '# xla_line_defn_jlt_assgns clear description = '||l_num_rows,

1313: p_amb_context_code => g_amb_context_code,
1314: p_application_id => g_application_id,
1315: p_request_code => 'IMPORT' ,
1316: p_log_type_code => 'MERGE',
1317: p_encoded_message => '# xla_line_defn_jlt_assgns clear description = '||l_num_rows,
1318: p_component_code => 'clean_oracle_descriptions');
1319:
1320: FORALL i IN 1..l_codes.COUNT
1321: UPDATE xla_prod_acct_headers

Line 2795: 'XLA_LINE_DEFN_JLT_ASSGNS'

2791: select event_class_code,
2792: event_type_code,
2793: line_definition_code,
2794: accounting_line_code,
2795: 'XLA_LINE_DEFN_JLT_ASSGNS'
2796: from
2797: (select event_class_code,
2798: event_type_code,
2799: line_definition_code,

Line 2801: 'XLA_LINE_DEFN_JLT_ASSGNS',

2797: (select event_class_code,
2798: event_type_code,
2799: line_definition_code,
2800: accounting_line_code,
2801: 'XLA_LINE_DEFN_JLT_ASSGNS',
2802: amb_context_code,
2803: last_update_date ,
2804: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2805: from

Line 2810: 'XLA_LINE_DEFN_JLT_ASSGNS',

2806: (select event_class_code,
2807: event_type_code,
2808: line_definition_code,
2809: accounting_line_code,
2810: 'XLA_LINE_DEFN_JLT_ASSGNS',
2811: amb_context_code,
2812: last_update_date ,
2813: lag(last_update_date) over (PARTITION by application_id,
2814: event_class_code,

Line 2822: from XLA_LINE_DEFN_JLT_ASSGNS

2818: accounting_line_code,
2819: accounting_line_type_code
2820: order by amb_context_code
2821: ) lag_date
2822: from XLA_LINE_DEFN_JLT_ASSGNS
2823: order by amb_context_code
2824: ) x
2825: where x.amb_context_code =g_staging_context_code
2826: )

Line 2831: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_defn_jlt_assgns is :'||l_num_rows,

2827: where flag = 'False';
2828: l_num_rows := SQL%ROWCOUNT;
2829:
2830: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2831: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_defn_jlt_assgns is :'||l_num_rows,
2832: p_module => l_log_module,
2833: p_level => C_LEVEL_PROCEDURE);
2834: END IF;
2835: -- Bug : 9923803

Line 2842: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_jlt_assgns is :'||l_num_rows,

2838: p_amb_context_code => g_amb_context_code,
2839: p_application_id => g_application_id,
2840: p_request_code => 'IMPORT' ,
2841: p_log_type_code => 'MERGE',
2842: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_jlt_assgns is :'||l_num_rows,
2843: p_component_code => 'merge_journal_line_defns');
2844:
2845: INSERT INTO xla_aads_gt
2846: ( event_class_code,

Line 3367: DELETE FROM xla_line_defn_jlt_assgns w

3363: p_log_type_code => 'MERGE',
3364: p_encoded_message =>'# xla_line_definitions_tl deleted : '||l_num_rows,
3365: p_component_code => 'merge_journal_line_defns');
3366:
3367: DELETE FROM xla_line_defn_jlt_assgns w
3368: WHERE application_id = g_application_id
3369: AND amb_context_code = g_amb_context_code
3370: AND EXISTS (SELECT 1
3371: FROM xla_line_defn_jlt_assgns s

Line 3371: FROM xla_line_defn_jlt_assgns s

3367: DELETE FROM xla_line_defn_jlt_assgns w
3368: WHERE application_id = g_application_id
3369: AND amb_context_code = g_amb_context_code
3370: AND EXISTS (SELECT 1
3371: FROM xla_line_defn_jlt_assgns s
3372: WHERE s.application_id = g_application_id
3373: AND s.amb_context_code = g_staging_context_code
3374: AND s.event_class_code = w.event_class_code
3375: AND s.event_type_code = w.event_type_code

Line 3383: trace(p_msg => '# xla_line_defn_jlt_assgns deleted : '||l_num_rows,

3379: AND s.accounting_line_code = w.accounting_line_code);
3380:
3381: l_num_rows := SQL%ROWCOUNT;
3382: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3383: trace(p_msg => '# xla_line_defn_jlt_assgns deleted : '||l_num_rows,
3384: p_module => l_log_module,
3385: p_level => C_LEVEL_STATEMENT);
3386: END IF;
3387: -- Bug : 9923803

Line 3394: p_encoded_message =>'# xla_line_defn_jlt_assgns deleted : '||l_num_rows,

3390: p_amb_context_code => g_amb_context_code,
3391: p_application_id => g_application_id,
3392: p_request_code => 'IMPORT' ,
3393: p_log_type_code => 'MERGE',
3394: p_encoded_message =>'# xla_line_defn_jlt_assgns deleted : '||l_num_rows,
3395: p_component_code => 'merge_journal_line_defns');
3396:
3397: -- ADR assignment is not merged, but overwritten, if the JLD exists in the
3398: -- staging area.

Line 3403: FROM xla_line_defn_jlt_assgns s

3399: DELETE FROM xla_line_defn_adr_assgns w
3400: WHERE application_id = g_application_id
3401: AND amb_context_code = g_amb_context_code
3402: AND EXISTS (SELECT 1
3403: FROM xla_line_defn_jlt_assgns s
3404: WHERE s.application_id = g_application_id
3405: AND s.amb_context_code = g_staging_context_code
3406: AND s.event_class_code = w.event_class_code
3407: AND s.event_type_code = w.event_type_code

Line 3700: UPDATE xla_line_defn_jlt_assgns

3696: p_log_type_code => 'MERGE',
3697: p_encoded_message => '# xla_line_definitions_tl 2 updated : '||l_num_rows,
3698: p_component_code => 'merge_journal_line_defns');
3699:
3700: UPDATE xla_line_defn_jlt_assgns
3701: SET amb_context_code = g_amb_context_code
3702: WHERE application_id = g_application_id
3703: AND amb_context_code = g_staging_context_code;
3704: l_num_rows := SQL%ROWCOUNT;

Line 3706: trace(p_msg => '# xla_line_defn_jlt_assgns updated : '||l_num_rows,

3702: WHERE application_id = g_application_id
3703: AND amb_context_code = g_staging_context_code;
3704: l_num_rows := SQL%ROWCOUNT;
3705: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3706: trace(p_msg => '# xla_line_defn_jlt_assgns updated : '||l_num_rows,
3707: p_module => l_log_module,
3708: p_level => C_LEVEL_STATEMENT);
3709: END IF;
3710: -- Bug : 9923803

Line 3717: p_encoded_message => '# xla_line_defn_jlt_assgns updated : '||l_num_rows,

3713: p_amb_context_code => g_amb_context_code,
3714: p_application_id => g_application_id,
3715: p_request_code => 'IMPORT' ,
3716: p_log_type_code => 'MERGE',
3717: p_encoded_message => '# xla_line_defn_jlt_assgns updated : '||l_num_rows,
3718: p_component_code => 'merge_journal_line_defns');
3719:
3720: UPDATE xla_line_defn_adr_assgns
3721: SET amb_context_code = g_amb_context_code