eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_TRANSFORM_BATCH dependencies on WIP_ENTITIES

Line 43: p_table_name => 'WIP_ENTITIES',

39: gma_common_logging.gma_migration_central_log
40: (p_run_id => p_migration_run_id,
41: p_log_level => fnd_log.level_procedure,
42: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
43: p_table_name => 'WIP_ENTITIES',
44: p_context => 'CREATE_WIP_ENTITY',
45: p_app_short_name => 'GMA');
46: update_wip_entities(p_migration_run_id => p_migration_run_id,
47: x_exception_count => x_failure_count);

Line 46: update_wip_entities(p_migration_run_id => p_migration_run_id,

42: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
43: p_table_name => 'WIP_ENTITIES',
44: p_context => 'CREATE_WIP_ENTITY',
45: p_app_short_name => 'GMA');
46: update_wip_entities(p_migration_run_id => p_migration_run_id,
47: x_exception_count => x_failure_count);
48:
49:
50: gma_common_logging.gma_migration_central_log

Line 258: PROCEDURE update_wip_entities(p_migration_run_id IN NUMBER,

254: p_context => 'UPDATE_LAB_IND',
255: p_app_short_name => 'GMA');
256: END update_batch_header;
257:
258: PROCEDURE update_wip_entities(p_migration_run_id IN NUMBER,
259: x_exception_count OUT NOCOPY NUMBER) IS
260: l_wip_entity_id NUMBER;
261: l_batch_id NUMBER;
262: l_count NUMBER;

Line 272: FROM wip_entities

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
272: FROM wip_entities
273: WHERE organization_id = b.organization_id
274: AND ((b.batch_type = 0 AND entity_type = 10)
275: OR (b.batch_type = 10 AND entity_type = 9)));
276:

Line 283: INSERT INTO wip_entities

279: l_batch_prefix := NVL(get_profile_value ('GME_BATCH_PREFIX', 553),'BATCH');
280: l_fpo_prefix := NVL(get_profile_value ('GME_FPO_PREFIX', 553),'FPO');
281: FOR rec IN get_batches LOOP
282: BEGIN
283: INSERT INTO wip_entities
284: (wip_entity_id, organization_id,
285: last_update_date, last_updated_by, creation_date,
286: created_by, last_update_login, request_id,
287: program_application_id, program_id,

Line 292: VALUES (wip_entities_s.NEXTVAL,

288: program_update_date, wip_entity_name,
289: entity_type, description,
290: primary_item_id, gen_object_id
291: )
292: VALUES (wip_entities_s.NEXTVAL,
293: rec.organization_id, --ORGANIZATION_ID
294: SYSDATE, --LAST_UPDATE_DATE
295: 1, --LAST_UPDATED_BY,
296: SYSDATE, --CREATION_DATE,

Line 316: p_table_name => 'WIP_ENTITIES',

312: gma_common_logging.gma_migration_central_log
313: (p_run_id => p_migration_run_id,
314: p_log_level => fnd_log.level_unexpected,
315: p_message_token => 'GMA_MIGRATION_DB_ERROR',
316: p_table_name => 'WIP_ENTITIES',
317: p_context => 'CREATE_WIP_ENTITY',
318: p_db_error => SQLERRM,
319: p_app_short_name => 'GMA');
320: gma_common_logging.gma_migration_central_log

Line 324: p_table_name => 'WIP_ENTITIES',

320: gma_common_logging.gma_migration_central_log
321: (p_run_id => p_migration_run_id,
322: p_log_level => fnd_log.level_unexpected,
323: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
324: p_table_name => 'WIP_ENTITIES',
325: p_context => 'CREATE_WIP_ENTITY',
326: p_app_short_name => 'GMA');
327: END;
328: END LOOP;

Line 331: FROM wip_entities;

327: END;
328: END LOOP;
329: SELECT MAX (wip_entity_id)
330: INTO l_wip_entity_id
331: FROM wip_entities;
332:
333: SELECT MAX (batch_id)
334: INTO l_batch_id
335: FROM gme_batch_header;

Line 338: SELECT wip_entities_s.NEXTVAL

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
340: FROM DUAL;
341: END LOOP;
342: gma_common_logging.gma_migration_central_log

Line 346: p_table_name => 'WIP_ENTITIES',

342: gma_common_logging.gma_migration_central_log
343: (p_run_id => p_migration_run_id,
344: p_log_level => fnd_log.level_procedure,
345: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
346: p_table_name => 'WIP_ENTITIES',
347: p_context => 'CREATE_WIP_ENTITY',
348: p_token1 => 'PARAM1',
349: p_param1 => l_count,
350: p_app_short_name => 'GMA');

Line 358: p_table_name => 'WIP_ENTITIES',

354: gma_common_logging.gma_migration_central_log
355: (p_run_id => p_migration_run_id,
356: p_log_level => fnd_log.level_unexpected,
357: p_message_token => 'GMA_MIGRATION_DB_ERROR',
358: p_table_name => 'WIP_ENTITIES',
359: p_context => 'CREATE_WIP_ENTITY',
360: p_db_error => SQLERRM,
361: p_app_short_name => 'GMA');
362: gma_common_logging.gma_migration_central_log

Line 366: p_table_name => 'WIP_ENTITIES',

362: gma_common_logging.gma_migration_central_log
363: (p_run_id => p_migration_run_id,
364: p_log_level => fnd_log.level_unexpected,
365: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
366: p_table_name => 'WIP_ENTITIES',
367: p_context => 'CREATE_WIP_ENTITY',
368: p_app_short_name => 'GMA',
369: p_db_error => SQLERRM);
370: END update_wip_entities;

Line 370: END update_wip_entities;

366: p_table_name => 'WIP_ENTITIES',
367: p_context => 'CREATE_WIP_ENTITY',
368: p_app_short_name => 'GMA',
369: p_db_error => SQLERRM);
370: END update_wip_entities;
371:
372: PROCEDURE update_from_doc_no(p_migration_run_id NUMBER) IS
373: BEGIN
374: UPDATE gme_gantt_document_filter