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 265: UPDATE gme_batch_header h

261:
262: PROCEDURE update_batch_header(p_migration_run_id IN NUMBER,
263: x_exception_count OUT NOCOPY NUMBER) IS
264: BEGIN
265: UPDATE gme_batch_header h
266: SET laboratory_ind = (SELECT DECODE (org.plant_ind, 1, 0, 2, 1)
267: FROM sy_orgn_mst org
268: WHERE org.orgn_code = h.plant_code),
269: migrated_batch_ind = 'Y'

Line 275: p_table_name => 'GME_BATCH_HEADER',

271: gma_common_logging.gma_migration_central_log
272: (p_run_id => p_migration_run_id,
273: p_log_level => fnd_log.level_procedure,
274: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
275: p_table_name => 'GME_BATCH_HEADER',
276: p_context => 'UPDATE_LAB_IND',
277: p_param1 => SQL%ROWCOUNT,
278: p_app_short_name => 'GMA');
279: EXCEPTION

Line 286: p_table_name => 'GME_BATCH_HEADER',

282: gma_common_logging.gma_migration_central_log
283: (p_run_id => p_migration_run_id,
284: p_log_level => fnd_log.level_unexpected,
285: p_message_token => 'GMA_MIGRATION_DB_ERROR',
286: p_table_name => 'GME_BATCH_HEADER',
287: p_context => 'UPDATE_LAB_IND',
288: p_db_error => SQLERRM,
289: p_app_short_name => 'GMA');
290: gma_common_logging.gma_migration_central_log

Line 294: p_table_name => 'GME_BATCH_HEADER',

290: gma_common_logging.gma_migration_central_log
291: (p_run_id => p_migration_run_id,
292: p_log_level => fnd_log.level_unexpected,
293: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
294: p_table_name => 'GME_BATCH_HEADER',
295: p_context => 'UPDATE_LAB_IND',
296: p_app_short_name => 'GMA');
297: END update_batch_header;
298:

Line 310: FROM gme_batch_header b, gmd_recipe_validity_rules v

306:
307: /*
308: CURSOR get_batches IS
309: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
310: FROM gme_batch_header b, gmd_recipe_validity_rules v
311: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
312: AND b.organization_id IS NOT NULL
313: AND DECODE(batch_type, 0, l_batch_prefix, l_fpo_prefix)||batch_no
314: NOT IN (SELECT wip_entity_name

Line 330: FROM gme_batch_header b, wip_entities w

326: FROM wip_entities;
327:
328: CURSOR get_min_entity_id IS
329: SELECT NVL(min(wip_entity_id), 0)
330: FROM gme_batch_header b, wip_entities w
331: WHERE b.organization_id IS NOT NULL
332: AND DECODE(batch_type, 0, l_batch_prefix, l_fpo_prefix)||batch_no = w.wip_entity_name
333: and w.organization_id = b.organization_id
334: AND ((b.batch_type = 0 AND entity_type = 10)

Line 340: FROM gme_batch_header b, gmd_recipe_validity_rules v

336:
337: -- Let's get all batches minus the ones already in wip entities.
338: CURSOR get_batches IS
339: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
340: FROM gme_batch_header b, gmd_recipe_validity_rules v
341: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
342: AND b.organization_id IS NOT NULL
343: MINUS
344: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id

Line 345: FROM gme_batch_header b, gmd_recipe_validity_rules v,

341: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
342: AND b.organization_id IS NOT NULL
343: MINUS
344: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
345: FROM gme_batch_header b, gmd_recipe_validity_rules v,
346: (SELECT wip_entity_name, organization_id, entity_type
347: FROM wip_entities
348: WHERE wip_entity_id > l_min_wip_entity_id
349: AND entity_type IN (9, 10)) w

Line 437: FROM gme_batch_header;

433: FROM wip_entities;
434:
435: SELECT MAX (batch_id)
436: INTO l_batch_id
437: FROM gme_batch_header;
438:
439: WHILE l_wip_entity_id < l_batch_id LOOP
440: SELECT wip_entities_s.NEXTVAL
441: INTO l_wip_entity_id