APPS.MSD_CL_PRE_PROCESS dependencies on MSD_ST_SETUP_PARAMETERS

Line 7753: FROM msd_st_setup_parameters

7749:
7750:
7751: CURSOR c1 IS
7752: SELECT rowid
7753: FROM msd_st_setup_parameters
7754: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
7755: AND sr_instance_code = p_instance_code ;
7756:
7757:

Line 7762: FROM msd_st_setup_parameters

7758: CURSOR c2 IS
7759: SELECT instance,
7760: parameter_name,
7761: parameter_value
7762: FROM msd_st_setup_parameters
7763: WHERE instance = p_instance_id ;
7764:
7765: BEGIN
7766:

Line 7778: UPDATE msd_st_setup_parameters

7774: CLOSE c1;
7775:
7776: v_sql_stmt := 04;
7777: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7778: UPDATE msd_st_setup_parameters
7779: SET st_transaction_id = msd_st_setup_parameters_s.NEXTVAL,
7780: last_update_date = lv_current_date,
7781: last_updated_by = lv_current_user,
7782: creation_date = lv_current_date,

Line 7779: SET st_transaction_id = msd_st_setup_parameters_s.NEXTVAL,

7775:
7776: v_sql_stmt := 04;
7777: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7778: UPDATE msd_st_setup_parameters
7779: SET st_transaction_id = msd_st_setup_parameters_s.NEXTVAL,
7780: last_update_date = lv_current_date,
7781: last_updated_by = lv_current_user,
7782: creation_date = lv_current_date,
7783: created_by = lv_current_user

Line 7802: ' UPDATE msd_st_setup_parameters'

7798: -- Parameter value and parameter_name should not be null
7799:
7800: v_sql_stmt := 01;
7801: lv_sql_stmt :=
7802: ' UPDATE msd_st_setup_parameters'
7803: ||' SET process_flag = '||G_ERROR_FLG||','
7804: ||' error_text = '||''''||lv_message_text||''''
7805: ||' WHERE (NVL(parameter_name, '||''''||NULL_CHAR||''''||') '
7806: ||' = '||''''||NULL_CHAR||''''

Line 7820: (p_table_name => 'MSD_ST_SETUP_PARAMETERS',

7816: USING p_instance_code;
7817:
7818: -- Set the process flag as Valid and populate instance_id
7819: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
7820: (p_table_name => 'MSD_ST_SETUP_PARAMETERS',
7821: p_instance_id => p_instance_id,
7822: p_instance_code => p_instance_code,
7823: p_process_flag => G_VALID,
7824: p_error_text => lv_error_text,

Line 7857: DELETE FROM MSD_ST_SETUP_PARAMETERS

7853: c_rec.parameter_name,
7854: c_rec.parameter_value );
7855: END IF ;
7856:
7857: DELETE FROM MSD_ST_SETUP_PARAMETERS
7858: WHERE instance = c_rec.instance
7859: AND parameter_name = c_rec.parameter_name
7860: AND parameter_value = c_rec.parameter_value;
7861:

Line 7871: (p_table_name => 'MSD_ST_SETUP_PARAMETERS',

7867:
7868: -- Inserting all the errored out records into MSC_ERRORS:
7869:
7870: lv_return := MSC_ST_UTIL.LOG_ERROR
7871: (p_table_name => 'MSD_ST_SETUP_PARAMETERS',
7872: p_instance_code => p_instance_code,
7873: p_row => lv_column_names,
7874: p_severity => G_SEV_ERROR,
7875: p_error_text => lv_error_text,