DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_RESOURCE_CHANGES_S

Line 30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;

30467: lv_where_str VARCHAR2(5000);
30468: lv_sql_stmt VARCHAR2(5000);
30469: lv_cursor_stmt VARCHAR2(5000);
30470:
30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;
30472: lv_batch_id msc_st_department_resources.batch_id%TYPE;
30473: lv_message_text msc_errors.error_text%TYPE;
30474:
30475:

Line 32674: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,

32670:
32671: v_sql_stmt := 35;
32672: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32673: UPDATE msc_st_resource_changes
32674: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,
32675: refresh_id = v_refresh_id,
32676: last_update_date = v_current_date,
32677: last_updated_by = v_current_user,
32678: creation_date = v_current_date,