DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_ITEM_CUSTOMERS_S

Line 50176: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.

50172:
50173:
50174: -- Generate the st_transaction_id and update all the records with this st_transaction_id.
50175: -- Set the who columns also (where PROCESS_FLAG = 2 and SR_INSTANCE_CODE = v_instance_code).
50176: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
50177:
50178: v_sql_stmt := 07;
50179: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50180: UPDATE msc_st_item_customers

Line 50181: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,

50177:
50178: v_sql_stmt := 07;
50179: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50180: UPDATE msc_st_item_customers
50181: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
50182: refresh_id = v_refresh_id,
50183: last_update_date = v_current_date,
50184: last_updated_by = v_current_user,
50185: creation_date = v_current_date,