APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_APPLI_AMB_CONTEXTS

Line 114: INSERT INTO xla_appli_amb_contexts

110: p_module => l_log_module,
111: p_level => C_LEVEL_EVENT);
112: END IF;
113:
114: INSERT INTO xla_appli_amb_contexts
115: (application_id
116: ,amb_context_code
117: ,staging_amb_context_code
118: ,updated_flag

Line 142: FROM xla_appli_amb_contexts

138: ,xla_environment_pkg.g_usr_id
139: ,xla_environment_pkg.g_login_id
140: FROM dual
141: WHERE NOT EXISTS (SELECT 1
142: FROM xla_appli_amb_contexts
143: WHERE staging_amb_context_code = l_code);
144:
145: IF (SQL%ROWCOUNT = 0) THEN
146: l_code := NULL;

Line 1743: FROM xla_appli_amb_contexts

1739: RETURN VARCHAR2
1740: IS
1741: CURSOR c IS
1742: SELECT staging_amb_context_code
1743: FROM xla_appli_amb_contexts
1744: WHERE application_id = p_application_id
1745: AND amb_context_code = p_amb_context_code;
1746:
1747: l_temp_code VARCHAR2(80);

Line 1752: FROM xla_appli_amb_contexts

1748: l_staging_amb_context_code VARCHAR2(30);
1749:
1750: CURSOR c_exists IS
1751: SELECT 1
1752: FROM xla_appli_amb_contexts
1753: WHERE staging_amb_context_code = l_staging_amb_context_code;
1754:
1755: l_log_module VARCHAR2(240);
1756: BEGIN

Line 2941: FROM xla_appli_amb_contexts

2937: )
2938: IS
2939: CURSOR c_staging_context_code IS
2940: SELECT staging_amb_context_code
2941: FROM xla_appli_amb_contexts
2942: WHERE amb_context_code = p_amb_context_code
2943: AND application_id = p_application_id;
2944:
2945: l_staging_context_code VARCHAR2(30);

Line 3005: DELETE FROM xla_appli_amb_contexts

3001: p_module => l_log_module,
3002: p_level => C_LEVEL_PROCEDURE);
3003: END IF;
3004:
3005: DELETE FROM xla_appli_amb_contexts
3006: WHERE staging_amb_context_code = l_staging_context_code;
3007:
3008: -- Bug 16208537
3009: -- API Call to Insert messages into AAD Loader Log Table.

Line 3015: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,

3011: p_amb_context_code => l_staging_context_code,
3012: p_application_id => p_application_id,
3013: p_request_code => 'IMPORT' ,
3014: p_log_type_code => 'MERGE',
3015: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
3016: p_component_code => 'purge_aad');
3017:
3018: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3019: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,

Line 3019: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,

3015: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
3016: p_component_code => 'purge_aad');
3017:
3018: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3019: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,
3020: p_module => l_log_module,
3021: p_level => C_LEVEL_PROCEDURE);
3022: END IF;
3023:

Line 3083: DELETE FROM xla_appli_amb_contexts

3079: p_module => l_log_module,
3080: p_level => C_LEVEL_PROCEDURE);
3081: END IF;
3082:
3083: DELETE FROM xla_appli_amb_contexts
3084: WHERE staging_amb_context_code = p_amb_context_code;
3085:
3086: -- Bug 16208537
3087: -- API Call to Insert messages into AAD Loader Log Table.

Line 3093: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,

3089: p_amb_context_code => p_amb_context_code,
3090: p_application_id => p_application_id,
3091: p_request_code => 'IMPORT' ,
3092: p_log_type_code => 'MERGE',
3093: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
3094: p_component_code => 'purge_aad');
3095:
3096: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3097: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,

Line 3097: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,

3093: p_encoded_message => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
3094: p_component_code => 'purge_aad');
3095:
3096: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3097: trace(p_msg => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,
3098: p_module => l_log_module,
3099: p_level => C_LEVEL_PROCEDURE);
3100: END IF;
3101: