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_PROCESS_PARAMETERS_DBL dependencies on GME_COMMON_PVT

Line 106: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

102: ,x_process_parameters.attribute27
103: ,x_process_parameters.attribute28
104: ,x_process_parameters.attribute29
105: ,x_process_parameters.attribute30
106: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
107: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
108: ,gme_common_pvt.g_login_id)
109: RETURNING process_param_id
110: INTO x_process_parameters.process_param_id;

Line 107: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident

103: ,x_process_parameters.attribute28
104: ,x_process_parameters.attribute29
105: ,x_process_parameters.attribute30
106: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
107: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
108: ,gme_common_pvt.g_login_id)
109: RETURNING process_param_id
110: INTO x_process_parameters.process_param_id;
111:

Line 108: ,gme_common_pvt.g_login_id)

104: ,x_process_parameters.attribute29
105: ,x_process_parameters.attribute30
106: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
107: ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
108: ,gme_common_pvt.g_login_id)
109: RETURNING process_param_id
110: INTO x_process_parameters.process_param_id;
111:
112: IF SQL%FOUND THEN

Line 113: x_process_parameters.created_by := gme_common_pvt.g_user_ident;

109: RETURNING process_param_id
110: INTO x_process_parameters.process_param_id;
111:
112: IF SQL%FOUND THEN
113: x_process_parameters.created_by := gme_common_pvt.g_user_ident;
114: x_process_parameters.creation_date := gme_common_pvt.g_timestamp;
115: x_process_parameters.last_updated_by := gme_common_pvt.g_user_ident;
116: x_process_parameters.last_update_date := gme_common_pvt.g_timestamp;
117: RETURN TRUE;

Line 114: x_process_parameters.creation_date := gme_common_pvt.g_timestamp;

110: INTO x_process_parameters.process_param_id;
111:
112: IF SQL%FOUND THEN
113: x_process_parameters.created_by := gme_common_pvt.g_user_ident;
114: x_process_parameters.creation_date := gme_common_pvt.g_timestamp;
115: x_process_parameters.last_updated_by := gme_common_pvt.g_user_ident;
116: x_process_parameters.last_update_date := gme_common_pvt.g_timestamp;
117: RETURN TRUE;
118: ELSE

Line 115: x_process_parameters.last_updated_by := gme_common_pvt.g_user_ident;

111:
112: IF SQL%FOUND THEN
113: x_process_parameters.created_by := gme_common_pvt.g_user_ident;
114: x_process_parameters.creation_date := gme_common_pvt.g_timestamp;
115: x_process_parameters.last_updated_by := gme_common_pvt.g_user_ident;
116: x_process_parameters.last_update_date := gme_common_pvt.g_timestamp;
117: RETURN TRUE;
118: ELSE
119: RETURN FALSE;

Line 116: x_process_parameters.last_update_date := gme_common_pvt.g_timestamp;

112: IF SQL%FOUND THEN
113: x_process_parameters.created_by := gme_common_pvt.g_user_ident;
114: x_process_parameters.creation_date := gme_common_pvt.g_timestamp;
115: x_process_parameters.last_updated_by := gme_common_pvt.g_user_ident;
116: x_process_parameters.last_update_date := gme_common_pvt.g_timestamp;
117: RETURN TRUE;
118: ELSE
119: RETURN FALSE;
120: END IF;

Line 369: gme_common_pvt.log_message ('GME_NO_KEYS'

365: WHERE batchstep_resource_id =
366: p_process_parameters.batchstep_resource_id
367: AND parameter_id = p_process_parameters.parameter_id;
368: ELSE
369: gme_common_pvt.log_message ('GME_NO_KEYS'
370: ,'TABLE_NAME'
371: ,g_table_name);
372: RETURN FALSE;
373: END IF;

Line 378: gme_common_pvt.log_message ('GME_NO_KEYS'

374:
375: RETURN TRUE;
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378: gme_common_pvt.log_message ('GME_NO_KEYS'
379: ,'TABLE_NAME'
380: ,g_table_name);
381: RETURN FALSE;
382: WHEN OTHERS THEN

Line 448: gme_common_pvt.log_message ('GME_NO_KEYS'

444: WHERE batchstep_resource_id =
445: p_process_parameters.batchstep_resource_id
446: AND parameter_id = p_process_parameters.parameter_id;
447: ELSE
448: gme_common_pvt.log_message ('GME_NO_KEYS'
449: ,'TABLE_NAME'
450: ,g_table_name);
451: RETURN FALSE;
452: END IF;

Line 457: gme_common_pvt.log_message ('GME_NO_KEYS'

453:
454: IF SQL%FOUND THEN
455: RETURN TRUE;
456: ELSE
457: gme_common_pvt.log_message ('GME_NO_KEYS'
458: ,'TABLE_NAME'
459: ,g_table_name);
460: RETURN FALSE;
461: END IF;

Line 464: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

460: RETURN FALSE;
461: END IF;
462: EXCEPTION
463: WHEN app_exception.record_lock_exception THEN
464: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
465: ,'TABLE_NAME'
466: ,g_table_name
467: ,'RECORD'
468: ,'PROCESS PARAMETERS'

Line 567: ,last_updated_by = gme_common_pvt.g_user_ident

563: ,attribute27 = p_process_parameters.attribute27
564: ,attribute28 = p_process_parameters.attribute28
565: ,attribute29 = p_process_parameters.attribute29
566: ,attribute30 = p_process_parameters.attribute30
567: ,last_updated_by = gme_common_pvt.g_user_ident
568: ,last_update_date = gme_common_pvt.g_timestamp
569: ,last_update_login = gme_common_pvt.g_login_id
570: WHERE process_param_id = p_process_parameters.process_param_id
571: AND last_update_date = p_process_parameters.last_update_date;

Line 568: ,last_update_date = gme_common_pvt.g_timestamp

564: ,attribute28 = p_process_parameters.attribute28
565: ,attribute29 = p_process_parameters.attribute29
566: ,attribute30 = p_process_parameters.attribute30
567: ,last_updated_by = gme_common_pvt.g_user_ident
568: ,last_update_date = gme_common_pvt.g_timestamp
569: ,last_update_login = gme_common_pvt.g_login_id
570: WHERE process_param_id = p_process_parameters.process_param_id
571: AND last_update_date = p_process_parameters.last_update_date;
572: ELSE

Line 569: ,last_update_login = gme_common_pvt.g_login_id

565: ,attribute29 = p_process_parameters.attribute29
566: ,attribute30 = p_process_parameters.attribute30
567: ,last_updated_by = gme_common_pvt.g_user_ident
568: ,last_update_date = gme_common_pvt.g_timestamp
569: ,last_update_login = gme_common_pvt.g_login_id
570: WHERE process_param_id = p_process_parameters.process_param_id
571: AND last_update_date = p_process_parameters.last_update_date;
572: ELSE
573: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 573: gme_common_pvt.log_message ('GME_NO_KEYS'

569: ,last_update_login = gme_common_pvt.g_login_id
570: WHERE process_param_id = p_process_parameters.process_param_id
571: AND last_update_date = p_process_parameters.last_update_date;
572: ELSE
573: gme_common_pvt.log_message ('GME_NO_KEYS'
574: ,'TABLE_NAME'
575: ,g_table_name);
576: RETURN FALSE;
577: END IF;

Line 583: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

579: IF SQL%FOUND THEN
580: RETURN TRUE;
581: ELSE
582: IF l_dummy = 0 THEN
583: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
584: ,'TABLE_NAME'
585: ,g_table_name);
586: ELSE
587: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 587: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

583: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
584: ,'TABLE_NAME'
585: ,g_table_name);
586: ELSE
587: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
588: ,'TABLE_NAME'
589: ,g_table_name);
590: END IF;
591:

Line 597: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'

593: END IF;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: IF l_dummy = 0 THEN
597: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
598: ,'TABLE_NAME'
599: ,g_table_name);
600: ELSE
601: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

Line 601: gme_common_pvt.log_message ('GME_RECORD_CHANGED'

597: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
598: ,'TABLE_NAME'
599: ,g_table_name);
600: ELSE
601: gme_common_pvt.log_message ('GME_RECORD_CHANGED'
602: ,'TABLE_NAME'
603: ,g_table_name);
604: END IF;
605:

Line 608: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

604: END IF;
605:
606: RETURN FALSE;
607: WHEN app_exception.record_lock_exception THEN
608: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
609: ,'TABLE_NAME'
610: ,g_table_name
611: ,'RECORD'
612: ,'PROCESS PARAMETERS'

Line 673: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

669:
670: RETURN TRUE;
671: EXCEPTION
672: WHEN app_exception.record_lock_exception THEN
673: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
674: ,'TABLE_NAME'
675: ,g_table_name
676: ,'RECORD'
677: ,'PROCESS PARAMETERS'

Line 719: l_process_param_ids gme_common_pvt.number_tab;

715: FUNCTION delete_all (
716: p_process_parameters IN gme_process_parameters%ROWTYPE)
717: RETURN BOOLEAN
718: IS
719: l_process_param_ids gme_common_pvt.number_tab;
720: locked_by_other_user EXCEPTION;
721: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
722: BEGIN
723: IF p_process_parameters.batchstep_resource_id IS NOT NULL THEN

Line 742: gme_common_pvt.log_message ('GME_RECORD_LOCKED'

738: RETURN TRUE;
739: END IF;
740: EXCEPTION
741: WHEN app_exception.record_lock_exception THEN
742: gme_common_pvt.log_message ('GME_RECORD_LOCKED'
743: ,'TABLE_NAME'
744: ,g_table_name
745: ,'RECORD'
746: ,'PROCESS PARAMETERS'