DBA Data[Home] [Help]

APPS.GME_TRANSFORM_BATCH dependencies on GME_PARAMETERS

Line 23: p_table_name => 'GME_PARAMETERS',

19: gma_common_logging.gma_migration_central_log
20: (p_run_id => p_migration_run_id,
21: p_log_level => fnd_log.level_procedure,
22: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
23: p_table_name => 'GME_PARAMETERS',
24: p_context => 'PROFILES',
25: p_app_short_name => 'GMA');
26: create_gme_parameters(p_migration_run_id => p_migration_run_id,
27: x_exception_count => x_failure_count);

Line 26: create_gme_parameters(p_migration_run_id => p_migration_run_id,

22: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
23: p_table_name => 'GME_PARAMETERS',
24: p_context => 'PROFILES',
25: p_app_short_name => 'GMA');
26: create_gme_parameters(p_migration_run_id => p_migration_run_id,
27: x_exception_count => x_failure_count);
28:
29: gma_common_logging.gma_migration_central_log
30: (p_run_id => p_migration_run_id,

Line 109: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,

105: --end bug 13086505
106: END get_profile_value;
107:
108:
109: PROCEDURE create_gme_parameters(p_migration_run_id IN NUMBER,
110: x_exception_count OUT NOCOPY NUMBER) IS
111: CURSOR get_plant_and_labs IS
112: SELECT sy.organization_id, sy.orgn_code plant_code
113: FROM sy_orgn_mst sy

Line 115: FROM gme_parameters

111: CURSOR get_plant_and_labs IS
112: SELECT sy.organization_id, sy.orgn_code plant_code
113: FROM sy_orgn_mst sy
114: WHERE NOT EXISTS (SELECT 1
115: FROM gme_parameters
116: WHERE organization_id = sy.organization_id)
117: AND sy.organization_id IS NOT NULL;
118:
119: CURSOR get_doc_numbering (v_doc_type IN VARCHAR2, v_plant_code IN VARCHAR2) IS

Line 145: column in the gme_parameters

141: CLOSE get_doc_numbering;
142:
143: /*
144: bug 13086505:Add copying profile 'GME_IB_FACTOR' value to 'ib_factor_id'
145: column in the gme_parameters
146: */
147:
148: INSERT INTO gme_parameters
149: (organization_id, auto_consume_supply_sub_only,

Line 148: INSERT INTO gme_parameters

144: bug 13086505:Add copying profile 'GME_IB_FACTOR' value to 'ib_factor_id'
145: column in the gme_parameters
146: */
147:
148: INSERT INTO gme_parameters
149: (organization_id, auto_consume_supply_sub_only,
150: supply_subinventory, supply_locator_id,
151: yield_subinventory, yield_locator_id,
152: delete_material_ind,

Line 209: p_table_name => 'GME_PARAMETERS',

205: l_count := l_count + 1;
206: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,
207: p_log_level => fnd_log.level_procedure,
208: p_message_token => 'GME_CREATE_PARAMS_SUCCESS',
209: p_table_name => 'GME_PARAMETERS',
210: p_context => 'PROFILES',
211: p_token1 => 'ORG_CODE',
212: p_param1 => rec.plant_code,
213: p_app_short_name => 'GME');

Line 221: p_table_name => 'GME_PARAMETERS',

217: gma_common_logging.gma_migration_central_log
218: (p_run_id => p_migration_run_id,
219: p_log_level => fnd_log.level_unexpected,
220: p_message_token => 'GMA_MIGRATION_DB_ERROR',
221: p_table_name => 'GME_PARAMETERS',
222: p_context => 'PROFILES',
223: p_db_error => SQLERRM,
224: p_app_short_name => 'GMA');
225: gma_common_logging.gma_migration_central_log

Line 229: p_table_name => 'GME_PARAMETERS',

225: gma_common_logging.gma_migration_central_log
226: (p_run_id => p_migration_run_id,
227: p_log_level => fnd_log.level_unexpected,
228: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
229: p_table_name => 'GME_PARAMETERS',
230: p_context => 'PROFILES',
231: p_app_short_name => 'GMA');
232: END;
233: END LOOP;

Line 238: p_table_name => 'GME_PARAMETERS',

234: gma_common_logging.gma_migration_central_log
235: (p_run_id => p_migration_run_id,
236: p_log_level => fnd_log.level_procedure,
237: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
238: p_table_name => 'GME_PARAMETERS',
239: p_context => 'PROFILES',
240: p_param1 => l_count,
241: p_app_short_name => 'GMA');
242: EXCEPTION

Line 249: p_table_name => 'GME_PARAMETERS',

245: gma_common_logging.gma_migration_central_log
246: (p_run_id => p_migration_run_id,
247: p_log_level => fnd_log.level_unexpected,
248: p_message_token => 'GMA_MIGRATION_DB_ERROR',
249: p_table_name => 'GME_PARAMETERS',
250: p_context => 'PROFILES',
251: p_db_error => SQLERRM,
252: p_app_short_name => 'GMA');
253: gma_common_logging.gma_migration_central_log

Line 257: p_table_name => 'GME_PARAMETERS',

253: gma_common_logging.gma_migration_central_log
254: (p_run_id => p_migration_run_id,
255: p_log_level => fnd_log.level_unexpected,
256: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
257: p_table_name => 'GME_PARAMETERS',
258: p_context => 'PROFILES',
259: p_app_short_name => 'GMA');
260: END create_gme_parameters;
261:

Line 260: END create_gme_parameters;

256: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
257: p_table_name => 'GME_PARAMETERS',
258: p_context => 'PROFILES',
259: p_app_short_name => 'GMA');
260: END create_gme_parameters;
261:
262: PROCEDURE update_batch_header(p_migration_run_id IN NUMBER,
263: x_exception_count OUT NOCOPY NUMBER) IS
264: BEGIN