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;
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:
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
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;
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
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;
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;
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;
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
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;
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;
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'
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;
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
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'
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;
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'
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:
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'
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:
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'
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'
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
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'