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.

[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 259: DELETE FROM xla_line_defn_adr_assgns

255: p_module => l_log_module,
256: p_level => C_LEVEL_STATEMENT);
257: END IF;
258:
259: DELETE FROM xla_line_defn_adr_assgns
260: WHERE application_id = p_application_id
261: AND amb_context_code = p_amb_context_code;
262:
263: -- Bug : 16208537

Line 270: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,

266: p_amb_context_code => p_amb_context_code,
267: p_application_id => p_application_id,
268: p_request_code => 'IMPORT' ,
269: p_log_type_code => 'MERGE',
270: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
271: p_component_code => 'purge');
272:
273: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
274: trace(p_msg => '# record deleted from xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,

Line 274: trace(p_msg => '# record deleted from xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,

270: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
271: p_component_code => 'purge');
272:
273: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
274: trace(p_msg => '# record deleted from xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,
275: p_module => l_log_module,
276: p_level => C_LEVEL_STATEMENT);
277: END IF;
278:

Line 898: FROM xla_line_defn_adr_assgns

894: FOR UPDATE NOWAIT;
895:
896: CURSOR c_line_defn_adr_assgns IS
897: SELECT *
898: FROM xla_line_defn_adr_assgns
899: WHERE application_id = p_application_id
900: AND amb_context_code = p_amb_context_code
901: FOR UPDATE NOWAIT;
902:

Line 3361: DELETE FROM xla_line_defn_adr_assgns

3357: p_module => l_log_module,
3358: p_level => C_LEVEL_PROCEDURE);
3359: END IF;
3360:
3361: DELETE FROM xla_line_defn_adr_assgns
3362: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3363: AND application_id = p_application_id;
3364:
3365: -- Bug 16208537

Line 3372: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,

3368: p_amb_context_code => p_amb_context_code,
3369: p_application_id => p_application_id,
3370: p_request_code => 'IMPORT' ,
3371: p_log_type_code => 'MERGE',
3372: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
3373: p_component_code => 'purge_aad');
3374:
3375: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3376: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

Line 3376: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

3372: p_encoded_message => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
3373: p_component_code => 'purge_aad');
3374:
3375: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3376: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
3377: p_module => l_log_module,
3378: p_level => C_LEVEL_PROCEDURE);
3379: END IF;
3380:

Line 3960: FROM xla_line_defn_adr_assgns xld

3956: SELECT app.application_name
3957: , xst.name segment_rule_name
3958: , lk1.meaning segment_rule_owner
3959: , xld.adr_version_num version_num
3960: FROM xla_line_defn_adr_assgns xld
3961: , xla_seg_rules_b xsr
3962: , xla_seg_rules_tl xst
3963: , fnd_application_vl app
3964: , xla_lookups lk1