APPS.MSD_CL_PRE_PROCESS dependencies on MSD_ST_UOM_CONVERSIONS

Line 7537: lv_batch_id msd_st_uom_conversions.batch_id%TYPE;

7533: IS
7534: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7535: lb_rowid RowidTab;
7536: lv_sql_stmt VARCHAR2(4000);
7537: lv_batch_id msd_st_uom_conversions.batch_id%TYPE;
7538: lv_message_text msc_errors.error_text%TYPE;
7539: lv_error_text VARCHAR2(250);
7540: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7541: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 7550: FROM msd_st_uom_conversions

7546: lv_column_names VARCHAR2(5000);
7547:
7548: CURSOR c1(p_batch_id NUMBER)IS
7549: SELECT rowid
7550: FROM msd_st_uom_conversions
7551: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
7552: AND sr_instance_code = p_instance_code
7553: AND batch_id = p_batch_id;
7554:

Line 7576: UPDATE msd_st_uom_conversions

7572: CLOSE c1;
7573:
7574: v_sql_stmt := 04;
7575: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7576: UPDATE msd_st_uom_conversions
7577: SET st_transaction_id = msd_st_uom_conversions_s.NEXTVAL,
7578: last_update_date = lv_current_date,
7579: last_updated_by = lv_current_user,
7580: creation_date = lv_current_date,

Line 7577: SET st_transaction_id = msd_st_uom_conversions_s.NEXTVAL,

7573:
7574: v_sql_stmt := 04;
7575: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7576: UPDATE msd_st_uom_conversions
7577: SET st_transaction_id = msd_st_uom_conversions_s.NEXTVAL,
7578: last_update_date = lv_current_date,
7579: last_updated_by = lv_current_user,
7580: creation_date = lv_current_date,
7581: created_by = lv_current_user

Line 7609: 'UPDATE msd_st_uom_conversions'

7605:
7606: v_sql_stmt := 05;
7607:
7608: lv_sql_stmt :=
7609: 'UPDATE msd_st_uom_conversions'
7610: ||' SET process_flag = '||G_ERROR_FLG||','
7611: ||' error_text = '||''''||lv_message_text||''''
7612: ||' WHERE (NVL(from_uom_class, '||''''||NULL_CHAR||''''||') '
7613: ||' = '||''''||NULL_CHAR||''''

Line 7649: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',

7645:
7646: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
7647:
7648: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
7649: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7650: p_column_name => 'ITEM',
7651: p_pk_col_name => 'SR_ITEM_PK',
7652: p_instance_code => p_instance_code,
7653: p_level_id => 1,

Line 7671: pEntityName => 'MSD_ST_UOM_CONVERSIONS',

7667: (ERRBUF => lv_error_text,
7668: RETCODE => lv_return,
7669: pBatchID => lv_batch_id,
7670: pInstanceCode => p_instance_code,
7671: pEntityName => 'MSD_ST_UOM_CONVERSIONS',
7672: pInstanceID => p_instance_id);
7673:
7674: IF NVL(lv_return,0) <> 0 THEN
7675: RAISE ex_logging_err;

Line 7680: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',

7676: END IF;
7677:
7678: -- Set the process flag as Valid and populate instance_id
7679: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
7680: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7681: p_instance_id => p_instance_id,
7682: p_instance_code => p_instance_code,
7683: p_process_flag => G_VALID,
7684: p_error_text => lv_error_text,

Line 7695: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',

7691:
7692: -- Inserting all the errored out records into MSC_ERRORS:
7693:
7694: lv_return := MSC_ST_UTIL.LOG_ERROR
7695: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7696: p_instance_code => p_instance_code,
7697: p_row => lv_column_names,
7698: p_severity => G_SEV_ERROR,
7699: p_error_text => lv_error_text,