APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_HDRS_B

Line 1019: FROM xla_analytical_hdrs_b b

1015: FOR UPDATE OF s.application_id NOWAIT;
1016:
1017: /*CURSOR c_analytical_hdrs IS
1018: SELECT *
1019: FROM xla_analytical_hdrs_b b
1020: ,xla_analytical_hdrs_tl t
1021: WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
1022: AND t.analytical_criterion_code = b.analytical_criterion_code
1023: AND t.amb_context_code = b.amb_context_code

Line 3524: FROM xla_analytical_hdrs_b h

3520: END IF;
3521:
3522: DELETE FROM xla_analytical_sources b
3523: WHERE EXISTS (SELECT 1
3524: FROM xla_analytical_hdrs_b h
3525: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3526: AND b.analytical_criterion_code = h.analytical_criterion_code
3527: AND b.amb_context_code = h.amb_context_code
3528: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)

Line 3550: FROM xla_analytical_hdrs_b h

3546: END IF;
3547:
3548: DELETE FROM xla_analytical_dtls_tl b
3549: WHERE EXISTS (SELECT 1
3550: FROM xla_analytical_hdrs_b h
3551: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3552: AND b.analytical_criterion_code = h.analytical_criterion_code
3553: AND b.amb_context_code = h.amb_context_code
3554: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)

Line 3575: FROM xla_analytical_hdrs_b h

3571: END IF;
3572:
3573: DELETE FROM xla_analytical_dtls_b b
3574: WHERE EXISTS (SELECT 1
3575: FROM xla_analytical_hdrs_b h
3576: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3577: AND b.analytical_criterion_code = h.analytical_criterion_code
3578: AND b.amb_context_code = h.amb_context_code
3579: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)

Line 3601: FROM xla_analytical_hdrs_b h

3597: END IF;
3598:
3599: DELETE FROM xla_analytical_hdrs_tl b
3600: WHERE EXISTS (SELECT 1
3601: FROM xla_analytical_hdrs_b h
3602: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
3603: AND b.analytical_criterion_code = h.analytical_criterion_code
3604: AND b.amb_context_code = h.amb_context_code
3605: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)

Line 3625: DELETE FROM xla_analytical_hdrs_b

3621: p_module => l_log_module,
3622: p_level => C_LEVEL_PROCEDURE);
3623: END IF;
3624:
3625: DELETE FROM xla_analytical_hdrs_b
3626: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3627: AND application_id = p_application_id;
3628:
3629: -- Bug 16208537

Line 3636: p_encoded_message => '# delete (xla_analytical_hdrs_b) = '||SQL%ROWCOUNT,

3632: p_amb_context_code => p_amb_context_code,
3633: p_application_id => p_application_id,
3634: p_request_code => 'IMPORT' ,
3635: p_log_type_code => 'MERGE',
3636: p_encoded_message => '# delete (xla_analytical_hdrs_b) = '||SQL%ROWCOUNT,
3637: p_component_code => 'purge_aad');
3638:
3639: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3640: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,

Line 3640: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,

3636: p_encoded_message => '# delete (xla_analytical_hdrs_b) = '||SQL%ROWCOUNT,
3637: p_component_code => 'purge_aad');
3638:
3639: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3640: trace(p_msg => '# xla_analytical_hdrs_b deleted = '||SQL%ROWCOUNT,
3641: p_module => l_log_module,
3642: p_level => C_LEVEL_PROCEDURE);
3643: END IF;
3644:

Line 3895: FROM xla_analytical_hdrs_b;

3891: CURSOR c_acs IS
3892: SELECT analytical_criterion_type_code
3893: , analytical_criterion_code
3894: , amb_context_code
3895: FROM xla_analytical_hdrs_b;
3896:
3897: l_ret_value INTEGER;
3898: l_log_module VARCHAR2(240);
3899: BEGIN

Line 4135: UPDATE xla_analytical_hdrs_b

4131: SET version_num = 0
4132: , updated_flag = 'Y'
4133: WHERE application_id = p_application_id;
4134:
4135: UPDATE xla_analytical_hdrs_b
4136: SET version_num = 0
4137: , updated_flag = 'Y'
4138: WHERE application_id = p_application_id;
4139: