APPS.MSD_CL_PRE_PROCESS dependencies on MSD_ST_CURRENCY_CONVERSIONS

Line 5721: lv_batch_id msd_st_currency_conversions.batch_id%TYPE;

5717: IS
5718: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5719: lb_rowid RowidTab;
5720: lv_sql_stmt VARCHAR2(4000);
5721: lv_batch_id msd_st_currency_conversions.batch_id%TYPE;
5722: lv_message_text msc_errors.error_text%TYPE;
5723: lv_error_text VARCHAR2(250);
5724: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5725: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 5734: FROM msd_st_currency_conversions

5730: lv_column_names VARCHAR2(5000);
5731:
5732: CURSOR c1(p_batch_id NUMBER)IS
5733: SELECT rowid
5734: FROM msd_st_currency_conversions
5735: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
5736: AND sr_instance_code = p_instance_code
5737: AND batch_id = p_batch_id;
5738:

Line 5756: UPDATE msd_st_currency_conversions

5752: CLOSE c1;
5753:
5754: v_sql_stmt := 04;
5755: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
5756: UPDATE msd_st_currency_conversions
5757: SET st_transaction_id = msd_st_currency_conversions_s.NEXTVAL,
5758: last_update_date = lv_current_date,
5759: last_updated_by = lv_current_user,
5760: creation_date = lv_current_date,

Line 5757: SET st_transaction_id = msd_st_currency_conversions_s.NEXTVAL,

5753:
5754: v_sql_stmt := 04;
5755: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
5756: UPDATE msd_st_currency_conversions
5757: SET st_transaction_id = msd_st_currency_conversions_s.NEXTVAL,
5758: last_update_date = lv_current_date,
5759: last_updated_by = lv_current_user,
5760: creation_date = lv_current_date,
5761: created_by = lv_current_user

Line 5783: 'UPDATE msd_st_currency_conversions'

5779: END IF;
5780:
5781: -- error out if conversion rate, conversion dfate, from or to currency is null
5782: lv_sql_stmt :=
5783: 'UPDATE msd_st_currency_conversions'
5784: ||' SET process_flag = '||G_ERROR_FLG||','
5785: ||' error_text = '||''''||lv_message_text||''''
5786: ||' WHERE (NVL(from_currency, '||''''||NULL_CHAR||''''||') '
5787: ||' = '||''''||NULL_CHAR||''''

Line 5809: pEntityName => 'MSD_ST_CURRENCY_CONVERSIONS',

5805: (ERRBUF => lv_error_text,
5806: RETCODE => lv_return,
5807: pBatchID => lv_batch_id,
5808: pInstanceCode => p_instance_code,
5809: pEntityName => 'MSD_ST_CURRENCY_CONVERSIONS',
5810: pInstanceID => p_instance_id);
5811:
5812: IF NVL(lv_return,0) <> 0 THEN
5813: RAISE ex_logging_err;

Line 5818: (p_table_name => 'MSD_ST_CURRENCY_CONVERSIONS',

5814: END IF;
5815:
5816: -- Set the process flag as Valid and populate instance_id
5817: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
5818: (p_table_name => 'MSD_ST_CURRENCY_CONVERSIONS',
5819: p_instance_id => p_instance_id,
5820: p_instance_code => p_instance_code,
5821: p_process_flag => G_VALID,
5822: p_error_text => lv_error_text,

Line 5833: (p_table_name => 'MSD_ST_CURRENCY_CONVERSIONS',

5829:
5830: -- Inserting all the errored out records into MSC_ERRORS:
5831:
5832: lv_return := MSC_ST_UTIL.LOG_ERROR
5833: (p_table_name => 'MSD_ST_CURRENCY_CONVERSIONS',
5834: p_instance_code => p_instance_code,
5835: p_row => lv_column_names,
5836: p_severity => G_SEV_ERROR,
5837: p_error_text => lv_error_text,