DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_ITEM_CUSTOMERS_S

Line 55090: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.

55086:
55087:
55088: -- Generate the st_transaction_id and update all the records with this st_transaction_id.
55089: -- Set the who columns also (where PROCESS_FLAG = 2 and SR_INSTANCE_CODE = v_instance_code).
55090: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
55091:
55092: v_sql_stmt := 07;
55093: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
55094: UPDATE msc_st_item_customers

Line 55095: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,

55091:
55092: v_sql_stmt := 07;
55093: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
55094: UPDATE msc_st_item_customers
55095: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
55096: refresh_id = v_refresh_id,
55097: last_update_date = v_current_date,
55098: last_updated_by = v_current_user,
55099: creation_date = v_current_date,