APPS.GME_TRANSFORM_BATCH dependencies on GME_BATCH_HEADER

Line 33: p_table_name => 'GME_BATCH_HEADER',

29: gma_common_logging.gma_migration_central_log
30: (p_run_id => p_migration_run_id,
31: p_log_level => fnd_log.level_procedure,
32: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
33: p_table_name => 'GME_BATCH_HEADER',
34: p_context => 'UPDATE_LAB_IND',
35: p_app_short_name => 'GMA');
36: update_batch_header(p_migration_run_id => p_migration_run_id,
37: x_exception_count => x_failure_count);

Line 224: UPDATE gme_batch_header h

220:
221: PROCEDURE update_batch_header(p_migration_run_id IN NUMBER,
222: x_exception_count OUT NOCOPY NUMBER) IS
223: BEGIN
224: UPDATE gme_batch_header h
225: SET laboratory_ind = (SELECT DECODE (org.plant_ind, 1, 0, 2, 1)
226: FROM sy_orgn_mst org
227: WHERE org.orgn_code = h.plant_code),
228: migrated_batch_ind = 'Y'

Line 234: p_table_name => 'GME_BATCH_HEADER',

230: gma_common_logging.gma_migration_central_log
231: (p_run_id => p_migration_run_id,
232: p_log_level => fnd_log.level_procedure,
233: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
234: p_table_name => 'GME_BATCH_HEADER',
235: p_context => 'UPDATE_LAB_IND',
236: p_param1 => SQL%ROWCOUNT,
237: p_app_short_name => 'GMA');
238: EXCEPTION

Line 245: p_table_name => 'GME_BATCH_HEADER',

241: gma_common_logging.gma_migration_central_log
242: (p_run_id => p_migration_run_id,
243: p_log_level => fnd_log.level_unexpected,
244: p_message_token => 'GMA_MIGRATION_DB_ERROR',
245: p_table_name => 'GME_BATCH_HEADER',
246: p_context => 'UPDATE_LAB_IND',
247: p_db_error => SQLERRM,
248: p_app_short_name => 'GMA');
249: gma_common_logging.gma_migration_central_log

Line 253: p_table_name => 'GME_BATCH_HEADER',

249: gma_common_logging.gma_migration_central_log
250: (p_run_id => p_migration_run_id,
251: p_log_level => fnd_log.level_unexpected,
252: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
253: p_table_name => 'GME_BATCH_HEADER',
254: p_context => 'UPDATE_LAB_IND',
255: p_app_short_name => 'GMA');
256: END update_batch_header;
257:

Line 267: FROM gme_batch_header b, gmd_recipe_validity_rules v

263: l_batch_prefix VARCHAR2(80);
264: l_fpo_prefix VARCHAR2(80);
265: CURSOR get_batches IS
266: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
267: FROM gme_batch_header b, gmd_recipe_validity_rules v
268: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
269: AND b.organization_id IS NOT NULL
270: AND DECODE(batch_type, 0, l_batch_prefix, l_fpo_prefix)||batch_no
271: NOT IN (SELECT wip_entity_name

Line 335: FROM gme_batch_header;

331: FROM wip_entities;
332:
333: SELECT MAX (batch_id)
334: INTO l_batch_id
335: FROM gme_batch_header;
336:
337: WHILE l_wip_entity_id < l_batch_id LOOP
338: SELECT wip_entities_s.NEXTVAL
339: INTO l_wip_entity_id