DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_COLLECTION_S

Line 52647: LCID= MSC_COLLECTION_S.NEXTVAL,

52643: RETCODE := G_SUCCESS;
52644:
52645: UPDATE MSC_APPS_INSTANCES
52646: SET ST_STATUS= G_ST_PRE_PROCESSING,
52647: LCID= MSC_COLLECTION_S.NEXTVAL,
52648: LAST_UPDATE_DATE= v_current_date,
52649: LAST_UPDATED_BY= v_current_user,
52650: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
52651: WHERE INSTANCE_ID= p_instance_id;

Line 52653: SELECT MSC_COLLECTION_S.CURRVAL

52649: LAST_UPDATED_BY= v_current_user,
52650: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
52651: WHERE INSTANCE_ID= p_instance_id;
52652:
52653: SELECT MSC_COLLECTION_S.CURRVAL
52654: INTO v_last_collection_id
52655: FROM DUAL;
52656:
52657: RETURN TRUE;